Title: wordpress value compare between two meta keys
Last modified: August 21, 2016

---

# wordpress value compare between two meta keys

 *  [anur](https://wordpress.org/support/users/anur/)
 * (@anur)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-value-compare-between-two-meta-keys/)
 * I have property plugin with two fields in the backend from Area and To Area.
   
   In the front end search also I have included two search fields min area and max
   So if either the min area or max area falls in range of property from area or
   to area then it should show up result..
 * Eg one of the properties has area between 1000-3000 as from area and to area 
   and anyone in the front end searches either 500-2000 or 1500 -6000 shld show 
   a result ,since in the first case 2000 falls in 1000-3000 range and in second
   case 1500 falls in 1000-3000 range.
    I dont know whats the exact way to write
   a meta query comparing a value between two keys with an OR condition this is 
   what I have achived, I get some results using <= or >= but dont know how to use
   between if possible please please write the code. `$meta_query = array( ‘relation’
   => ‘OR’, array(
 *  ‘key’ => array(‘property_frmarea’,’property_toarea’) (these are the 2 backend
   fields)
    ‘value’ => $_POST[‘from_size’], (this is front end from field) ‘type’
   => ‘numeric’, ‘compare’ => ‘Between’ ), array( ‘key’ => array(‘property_frmarea’,’
   property_toarea’) ‘value’ => $_POST[‘to_size’], ‘type’ => ‘numeric’, ‘compare’
   => ‘Between’ ), );

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Brandon Dove](https://wordpress.org/support/users/brandondove/)
 * (@brandondove)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-value-compare-between-two-meta-keys/#post-5053086)
 * Anur,
 * I think you have to approach it from an opposite perspective. Try the following
   example:
 * `
    <?php $meta_query = array( 'relation' => 'OR', array( 'key' => 'property_frmarea','
   value' => array( intval( $_POST['from_size'] ), // don't forget to escape user
   input intval( $_POST['to_size'] ) ), 'type' => 'UNSIGNED', 'compare' => 'BETWEEN'),
   array( 'key' => 'property_toarea', 'value' => array( intval( $_POST['from_size']),//
   don't forget to escape user input intval( $_POST['to_size'] ) ), 'type' => 'UNSIGNED','
   compare' => 'BETWEEN' ), );
 *  Thread Starter [anur](https://wordpress.org/support/users/anur/)
 * (@anur)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-value-compare-between-two-meta-keys/#post-5053262)
 * Yes that does give output but it works the opposite way…
    Its like this in the
   backend if a property has from size : 400 and to size :1000
 * So anyone who searches in min size or max size in that range will show a result.
   
   So some one searches for 600 -1200 will show a result since 600 falls in 400-
   1000 range Similarly some one searches 100-800 will show a result since 800 falls
   in 400-1000 range.
 * The solution you gave me works the opposite way it searches key betwen two values
   but I want the value to searcb between two keys.
    Hope some one can please help…
 *  [Brandon Dove](https://wordpress.org/support/users/brandondove/)
 * (@brandondove)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-value-compare-between-two-meta-keys/#post-5053269)
 * The only way to do that would be to construct your own custom SQL query.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘wordpress value compare between two meta keys’ is closed to new replies.

## Tags

 * [between](https://wordpress.org/support/topic-tag/between/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Brandon Dove](https://wordpress.org/support/users/brandondove/)
 * Last activity: [11 years, 10 months ago](https://wordpress.org/support/topic/wordpress-value-compare-between-two-meta-keys/#post-5053269)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics