Query all posts where meta value is empty

I think you forgot about the inherit post status. The default one in WP_Query is publish.

You should also use = instead of LIKE, to avoid using LIKE '%%' in the SQL query.

So try to add this:

'post_status' => 'inherit'

and

'compare' => '='

into your query arguments, to match the empty _wp_attachment_image_alt string values.

Related Posts:

  1. Meta Query with date and time on the same Day before given time
  2. meta_query: check if number exists
  3. Check if searched number is within the post meta value
  4. How to add date_query to meta_query array
  5. get_posts query is taking about 40 seconds to execute
  6. Slow query when selecting with large meta query or post__in
  7. Use not custom fields in get_posts() meta_query?
  8. WordPress extremely slow when using get_posts with multiple meta_query relations
  9. When to use WP_query(), query_posts() and pre_get_posts
  10. WP Query Args – Title or Meta Value
  11. Meta query with string starting like pattern
  12. how to show posts that are missing a meta_value
  13. Does tax_query really beats meta_query in all situations?
  14. Query WooCommerce orders where meta data does not exist
  15. Execute a large WP_Query with many “AND” Meta_Queries?
  16. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  17. Get_post() with meta_key when compare is a date
  18. querying with custom meta field with meta_query
  19. Order by two meta keys
  20. multiple meta key but get server load is very high
  21. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  22. Function to check if author has posted within the last x days
  23. Wp_query order by multiple custom fields?
  24. Order by meta_key in custom post type doesn’t affect the query
  25. Use meta_query to display events by date in custom field
  26. How to show recent and upcoming birthdays using meta_query
  27. Order Posts by meta value AND published date
  28. Using WP_Query and WP_Meta_Query Outside of WordPress
  29. If two first numbers exist in wp_meta_query value
  30. Create a sitemap without a plugin – get parent pages only?
  31. WP_Query on custom field and order results
  32. get_posts – find out if querystring was crap and fallback is used
  33. Creating query to show which editor (classic or block) was last used to edit a post/page
  34. Tax query clause inside a meta query clause?
  35. Return Taxonomy/Term Information with Posts (WP_Query/get_posts)
  36. Optional Meta Query
  37. How do I make a meta_query OR relation work? [closed]
  38. Weird orderby => post__in issue
  39. Meta_query on same meta key, with diffrenct values
  40. Can we return all category (not post) with Custom Query Filter? [closed]
  41. Extend product search with meta in WooCommerce
  42. how to make members list directory through wordpress post custom meta key.
  43. get posts by meta_key from inside key of post meta
  44. Help optimizing slow WP_Query with meta_query
  45. Conflict with get_posts and the_content
  46. 2 weeks ago from meta query meta value
  47. WP_Query with meta_query dosen’t return results
  48. How to show more post at a given category?
  49. Get posts by list of post IDs ordered by those IDs?
  50. Array as ‘key’ in WP_Query
  51. Reset WordPress Post Query to default
  52. Is it possible to query a custom field where the value is between two fields?
  53. How to provide meta_key array to wp_query?
  54. Searching for meta_key returns 0 posts
  55. Use WP_Query or query_posts() or get_posts() for optimizing a site?
  56. Specify strict ‘order by’ in WordPress query
  57. How to set up hierarchical relationships without using plugins / meta query
  58. Meta query compare for ID’s greater than specific ID
  59. Is it possible to add relation between meta_query and tax_query?
  60. WP_User_Query and user posts
  61. Show single posts date, in a page of posts
  62. WP_Query Class custom field parameters
  63. Why always one post missing
  64. meta_query where the meta value is not the post title
  65. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  66. Why my query is not “Main_query”?
  67. Facing problem with tax_query results
  68. How do i create a custom post query when the meta value is an array?
  69. meta_query with meta values as serialize arrays
  70. WP Query – grouping posts by same meta key, adding together values from another key
  71. Woocommerce Get Orders By Meta Value
  72. meta_query is overriding default search
  73. Multiple WP_Query args combinations according to post type
  74. WP_Query multiple value not working
  75. How to do WP_User_Query for Nested Array value Inside Nested Array field
  76. Query for current post
  77. WP_User_Query Orderby Not Working
  78. Unusual high query of user meta data
  79. Very slow query generated getting meta data from posts
  80. WordPress Query optimaization for slow query
  81. Meta query doesn’t remove placeholder escape before query
  82. get_posts query caching?
  83. WP Query Meta Query
  84. Query custom meta value – post view and date meta
  85. How can I modify standard search query to include also ACF custom fields values?
  86. Custom WP_query and integrating into theme file
  87. WP_Query – show posts where meta value and user_email match
  88. Best way to Order Post in Home without a plugin
  89. WP_Query using meta_query with LIKE doesn’t return what it should
  90. Is there any difference between below WP_Query code snippets?
  91. Both WP_Query and get_posts returning 1 post
  92. Return a single custom post from multiple meta queries
  93. query post based on comparison
  94. Including ‘cat’ => $cat breaks meta_query
  95. Query string form $_GET[‘value’] is not working as meta value in wp_query
  96. WP_Query orderby not working on custom post_type
  97. 294 Queries on Mainpage of WordPress
  98. Query custom post types by meta field in a term from custom taxonomy
  99. How do I have multiple metaqueries inside one wordpress query
  100. Display only posts with thumbnails

Leave a Comment