querying with custom meta field with meta_query

There’s actually a better solution that will (hopefully) be rolling out in WordPress 3.4 — you can run the patch as a hotfix now if you’d like, but here’s the TRAC link for the patch:

http://core.trac.wordpress.org/ticket/18158

With this, you can do …

    $my_query = new WP_Query( 
        array( 
            'meta_query' => array( 
                array(
                    'key' => 'foo',
                    'compare' => 'NOT EXISTS'
                )
            ) 
        ) 
    );

or, swap it out for ‘compare’ => ‘EXISTS’ instead if you like.

-George

Related Posts:

  1. Meta query with string starting like pattern
  2. compare meta_query in get_posts arguments
  3. Getting attachments by meta value
  4. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  5. WordPress altering my custom query, How to fix it?
  6. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  7. Order by meta_key in custom post type doesn’t affect the query
  8. meta_key and meta_value not working together
  9. Order Posts by meta value AND published date
  10. How to make Meta Query case sensitive?
  11. Fetch Record based on meta key dates
  12. Meta_query with multiple keys and multiple values
  13. meta_query BETWEEN, but the range is stored in the custom field
  14. Extend product search with meta in WooCommerce
  15. how to make members list directory through wordpress post custom meta key.
  16. Large AND OR query timing out
  17. meta_value_num not ordering all items
  18. meta_compare not comparing whole integer
  19. Display posts with specific value first in query
  20. Get every post with value in meta key
  21. add_query_arg to compare and display events from a certain date
  22. Comparing 2 Decimal Numbers from custom fields and displaying posts
  23. meta_query weird behaviour, static int will work, but not user data
  24. Query multiple post types, but different order for each
  25. Order by the first array within a meta_query
  26. Query ACF relationship field – Comparator IN – Value array
  27. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  28. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  29. How do i create a custom post query when the meta value is an array?
  30. WP Query – grouping posts by same meta key, adding together values from another key
  31. meta_query is overriding default search
  32. Trouble with serialized metadata
  33. Comparing Meta Field date in WPQuery using Meta_Query?
  34. Getting posts by custom field value
  35. Query against multiple locations within single custom post type post
  36. WP_Query, ACF field and array
  37. Order by Date Custom Field
  38. Query by meta value (add a dropdown of all values)
  39. Order Posts By Custom Field That is an array of objects
  40. Custom WP_query and integrating into theme file
  41. Using custom field as ‘orderby’ value causing post grouping by publish date
  42. Compare meta key separation
  43. query post based on comparison
  44. Get posts by meta value except one post [closed]
  45. How to get products with the same custom attribute like ean code
  46. Meta_query compare operator explanation
  47. meta_query ‘compare’ => ‘IN’ not working
  48. Sorting: custom query with orderby meta_value_num THEN by title
  49. WP_Query with checkbox meta_query
  50. Is “orderby” in WP Meta Query conflicting with Meta Query?
  51. Query two post types and order by two different date fields
  52. WP Meta Query for some meta (array) values
  53. Sort users by meta_value_num
  54. meta_query with array as value
  55. Using OR in WP_Query negates the “NOT EXISTS” compare
  56. Using WP Query to search within ALL keys in meta query
  57. WP Query – Get WooCommerce Products with variation that is in stock
  58. Meta_query with or without value
  59. How can i make WP_Query return post image and categories?
  60. How add a custom posttype name using ACF field to a query post array
  61. wp_query not searching with apostrophe
  62. Custom query based on meta key – Reduce three states to two in results?
  63. Add quicklink to in the Admin posts page where I can query by a meta_key
  64. Performance when getting post meta for post retrieved by meta value
  65. How to display multiple custom fields with the same meta_key in an ascending order?
  66. Order by empty custom field
  67. Tax query AND/OR meta query [duplicate]
  68. Help ordering Post loop by two meta values
  69. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  70. WP Query Meta Value – How To Identify Specific, Unique Values?
  71. Order by meta_key doesn’t work
  72. WP_QUERY with group by with custom fields
  73. Intiger meta value with ‘>=’ returns posts with lower value
  74. Multiple meta_key ordering with pre_get_posts
  75. Query using string from custom field as array value
  76. How to show list of posts with custom field value (a date) that are coming soon
  77. Meta query with compare by more than 2 fields
  78. WP_Query meta compare must include ALL array values
  79. meta_query returning excluded result
  80. Woocommerce Shortcode which displays a table with product data
  81. Creating a query that get all posts but places meta items first
  82. get_posts query is taking about 40 seconds to execute
  83. wp query to use both author id and meta_query
  84. WP_Query for a taxonomy value OR a custom post type meta field
  85. Meta query orderby meta_value_num sorting by role first
  86. Query post by Category and custom file (ACF)
  87. Sort custom post archives by a meta value from a different custom post type?
  88. meta_query is not allowing to show posts when querying multiple arguments in a WP_Query
  89. Speed up WP_query with meta comparing dates
  90. Meta Query if Values Don’t Exist
  91. How to show all the associated posts with specific date of data metabox?
  92. Is it possible to search for a string in posts OR postmeta?
  93. Custom search (wp query by custom fields)
  94. Selecting posts older than the current Unix epoch timestamp
  95. Custom Search Query – include only custom fields and title
  96. Why is WP_Query’s meta_query not filtering results?
  97. meta_query in wp_query not working as expected
  98. WP_Query – order with usort by custom meta
  99. WP query with multiple custom meta not respecting orderby
  100. Passing a variable containing a comma separated list of values in a meta-query

Leave a Comment