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 query posts based on lat-lng coordinate as post meta?
  46. Set Alias for meta_query arguments in get_posts()
  47. How can I use order_by to order by two meta_keys without excluding posts that don’t have those keys initialized?
  48. WP_Query orderby custom field then post_date in one query
  49. Trying to perform complex custom field query with order by set to field value
  50. datetime picker, timestamps and meta queries
  51. Sorting Posts by custom field
  52. Order posts by date and then by custom field
  53. Compare two meta-fields in a wp_query (where meta-field-A is larger than meta-field-B)
  54. Meta Query querrying several post types based on ACF fields is broken after update to WP 4.1
  55. How to get sum of meta_values of a meta_key in wp_query according to conditions
  56. Difference between ‘LIKE’ and ‘IN’ in meta queries
  57. Order WP Query posts by custom order calculated from post meta values
  58. how to speed up a complex wp_query?
  59. How to query for custom field within Gutenberg block from outside of that post? [closed]
  60. Meta Query for specific months
  61. Filtering by Post Meta Custom Fields – Performance
  62. Meta query with JSON value
  63. Get meta info related to current post
  64. ACF Date Based wp_query
  65. exclude posts with a specific custom field and value
  66. Returning a list of custom post types excluding those without a specific meta_value
  67. Get attachment by meta_key value
  68. Using meta_query with multiple keys and compare values
  69. Mysql query and order meta value
  70. Get a list of posts with associated meta_value
  71. Is it possible to set specific posts to show first in a query?
  72. Order ascending is ignored in meta query?
  73. database query with more than a couple meta hangs and doesn’t complete
  74. Search posts missing a particular custom field
  75. Conditional operator OR not working with custom fields
  76. Sort by presence of thumbnail
  77. it’s possible make a WP_Query with math operations?
  78. Sorting search results with custom dropdown
  79. Posts query according to meta box date
  80. create metabox to activate slider
  81. Query only displays one page_id
  82. Display post meta conditionally based on it’s value
  83. What’s missing in this wp_query and meta_query
  84. How to use the Term Object from a custom select field in a query
  85. meta_query order by date present -> future then show null
  86. Problem with my loops
  87. Sort posts on custom field AND after that sort on date?
  88. meta_query compare > not working
  89. Saving custom fields for WP_Query to retrieve
  90. Filter posts/pages by user_role array
  91. WP_Query with MetaQuery issue
  92. WP_Query with meta_value_num and meta_query not paged correctly
  93. Post Query not working after updating to 4.1
  94. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  95. Sort Posts with custom meta key by default which is currently set as optional
  96. WP_Query with several meta_query-statements and order by meta_value
  97. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  98. Get posts using multiple values from ACF checkbox as meta query wordpress
  99. WP Query returning all posts when Meta_query is null
  100. Order custom post type by posts with most likes first

Leave a Comment