Get result from meta_query() between two numbers

Multiple meta values can be compared with BETWEEN with an array value:

'meta_query' => array(
    array(
        'key'     => REALIA_PROPERTY_PREFIX .'attributes_area',
        'value'   => array( $first_val, $second_val ),
        'type'    => 'numeric',
        'compare' => 'BETWEEN',
    ), // inner array.
), // outer array.

You can see this in Developer Doc.

Related Posts:

  1. Meta query terribly slow
  2. meta_query sorting by 2 keys
  3. How to handle optional end date in compare clause in meta_query
  4. Using meta_query on pre_get_posts to exclude a particular meta_key value
  5. How to check a single number value against an array of meta_key values?
  6. Meta query with multiple logic (AND / OR)
  7. Best practice – Meta Query vs. post_clauses for “left join” ordering
  8. Different page parameters inside query
  9. meta_query key value from array
  10. LIKE %…% Meta Query
  11. Multiple Values stored as array in Meta Query
  12. Order by nested named meta queries with ‘exists’ and ‘not exists’
  13. Documentation for post meta
  14. Arrange Posts By Date In Order Of Closest To The Current Date
  15. Custom Upcoming Events List for Events Manager Plugin
  16. Very slow query with meta_query on large database
  17. How to use meta_query to check if a meta field has something set?
  18. User Relationship
  19. How to make a WP REST API query with meta_query in WP4.7?
  20. Edit post_content on posts with Featured Image
  21. Nested Queries using meta_query
  22. Use both meta query and tax query
  23. meta_query, number comparison, not quite working as it should
  24. Query posts only if meta_value is not empty
  25. How to pass user meta_key and meta_value (values as array)
  26. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  27. Query Multiple values for same key
  28. Comparing a field with several values at once with meta_query
  29. Meta query with a sub query group possible?
  30. meta_query compare=’!=’ with multiple custom fields
  31. Query posts with numeric meta values within a given range
  32. Fastest way to do meta query when I don’t need the actual posts, and just need post_id?
  33. meta_query not working on live site
  34. How do you get Posts by multiple meta_keys and meta_values with the Rest API V2?
  35. Query custom field with date
  36. Meta query with regular expression does not work
  37. Searching in title or meta, with a tax query too!
  38. WP User Query Issues
  39. Pre Get Posts / Multiple Meta Keys / Orderby Single Key
  40. Help on multiple meta_query
  41. Meta query – How to display a null meta key
  42. pre_get_posts and set
  43. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  44. How to query wp_postmeta table for any specific meta_value?
  45. User meta query results in PHP notice: only variables should be passed by reference
  46. meta_query with multiple values optimization
  47. Get a single post ID based on an exact match of 1 or more meta values
  48. How to use orderby with meta_query?
  49. meta_query with multiple key
  50. last_name + first_name orderby with meta_query [solved]
  51. meta query based on month regardless of year
  52. Extend meta query arguments
  53. get_posts( $args ) return empty data
  54. meta_query in WP_User_Query not working – returns every user, not just users where key & value matches
  55. how to get post meta where value is an array of key value pairs
  56. meta_query array in ‘values’ returns an error
  57. Meta Query Based on Month Range
  58. how to search all user meta data that have value like “vivek”
  59. Find posts by related taxonomy field
  60. wordpress meta value compare between two date
  61. Can I use pre_get_posts to add up values from two different meta_keys?
  62. WP JSON API meta_query not working
  63. Sorting posts by ACF field
  64. Ordering custom posts by meta field date
  65. latitude/longitude meta_query
  66. meta_query displays all results and none, my query is wrong
  67. How to properly escape values in meta query
  68. Fetch custom post related to a User
  69. How to Ordering by user meta
  70. Use meta_query in args for relationship
  71. meta_query Array
  72. meta_query compare “=“ returns nothing when it seems it should
  73. Order resultset by configured value and then list all the rest
  74. How to send variable to wp meta_query value?
  75. Issue with user meta_query
  76. How to get an archive page meta?
  77. Search for value(s) in meta field for a multi select
  78. Querying terms with calculations based on term meta data, sql vs. get_terms
  79. get_user can’t read variable
  80. meta_query check multiple date formats
  81. WordPress meta query not working
  82. Get meta_value from GDRating
  83. Why does this incorrect pre_get_posts meta_query work for sort order?
  84. Meta_Query with multi select values
  85. How to sort custom posts including null meta-values ​in admin columns with meta_query?
  86. Get Posts from Custom Meta Query
  87. get posts meta query returning the latest post if no meta key found
  88. Search using specific meta fields only (excluding post title and content)
  89. How to fetch WP_User_Query with multiple role arguments [duplicate]
  90. How to get meta value based on latest post id with group by term name
  91. Meta query not returning results even though the sql contains the information
  92. Display Users from two roles in one list
  93. Multiple Queries with meta_query
  94. Get foreach for meta_query value
  95. meta_query and strange orderby behaviour
  96. Sorting not working with get_posts
  97. order by meta_key [duplicate]
  98. Meta query with string NOT ending like pattern
  99. acf/save_post affecting WP_Query results
  100. Merge meta_value’s into a single row and then loop

Leave a Comment