Filter posts with meta_query NOT IN where value has multiple values

The NOT IN and != comparison operators work fine, however be aware that if you are using meta then your data may not be working in the way you expect. Specifically, meta_keys don’t have to be unique per post. A post can have _no_interest set to 1 AND have another meta row with it set to 2 as well.

So for example, if you have a post with _no_interest set to 1 and also set to 2 in another row, then even though you exclude 2, this post will still appear because it has a 1 on it in a different row.

Also, if you use IN or NOT IN, then your “value” parameter really should be an array of the values. So your value of ‘3’ there should be array(‘3’) instead.

Also be aware that having a meta that doesn’t exist for a post will give you unexpected results with a NOT IN as well. If you are doing posts with meta NOT IN some value, then posts which don’t have that meta at all also will not show up. In other words, they will have to have A value for the meta, just not THAT particular value. This is because specifying a meta causes an INNER JOIN to occur, which eliminates rows that lack that meta. The exception to this is using the NOT EXISTS comparison.

Related Posts:

  1. Mixing regular and custom post types (with meta_query) on home page
  2. WP_Query() show posts that end later than today
  3. WP_Query orderby custom field then post_date in one query
  4. Filtering a WP_Query meta_query by numeric values isn’t working
  5. Using Query Posts With Multiple Post Types And A Taxonomy
  6. Can’t sort order of wp_query with 2 meta keys
  7. Comparing timestamps in meta query doesn’t work
  8. Display two post types ordered by two custom fields
  9. Combine tax_query and meta_query in WP_Query
  10. query order by date on custom type: wrong order
  11. exclude custom post type by meta key in wp_query
  12. Filtering by Post Meta Custom Fields – Performance
  13. Is it possible to apply a meta_query to one specific post type in a query with multilple post types?
  14. Setting proper query for multiple custom admin filters
  15. WP_Query: include custom post type only with specific meta value
  16. Returning a list of custom post types excluding those without a specific meta_value
  17. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  18. wp_query check if integer exists in custom field’s array
  19. A method for ordering mixed dates in search result loop (theory only, no actual code)
  20. How to do WP_Query with two meta fields with orderby clause
  21. Stuck in Order by more then one
  22. Why is this query not working? (Standard posts + custom post type)
  23. Configuring a meta query with multiple post types that have the same relationship on a single page
  24. Possible to filter custom post type with multiple meta data?
  25. Query based on custom fields start and end date
  26. WP_query – Filter by tax_query and meta_query using multiple select
  27. Getting a custom post’s custom field based on another custom post’s custom field select
  28. find custom post type post by searching its custom field with my string
  29. WP_Query of custom post type sorted by meta_key has unexpected results
  30. Create a WP_Query where if the first value of the first row is equal to the second compare other value
  31. Query Posts, order by meta value
  32. WP_Meta_Query object with conditionals
  33. Sorting by meta_key different to search criteria?
  34. Using WP meta query to show custom post types by a start and finish date
  35. Two queries – one with checkbox ticked, one without – comparing meta_query
  36. How to order query results based on if a custom field has been populated, then the order by the date of the post?
  37. build child and anchestor three from post parent
  38. meta query condition don’t work
  39. Custom query result empty on page 2
  40. Use WP_query to match post types based on custom field values
  41. meta query multiple values for the same key
  42. Sort custom post archives by a meta value from a different custom post type?
  43. Custom post types – meta_query: search lesson which starts sooner
  44. post type => ‘any’ not applied my custom queries
  45. How to get the posts that my following users are liked?
  46. Meta_Query refuses to return results
  47. Not able to get my custom search result using meta_query and tax_query together?
  48. Querying, storing, and using data from 2 separate custom post types
  49. Query events post type after current date and timezone
  50. Conditional posts in WP_query for search
  51. Selecting posts older than the current Unix epoch timestamp
  52. Custom Query With Multiple Meta Key Value
  53. Trying to combine multiple WordPress queries
  54. Querying meta values within an array
  55. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  56. Order Wp Query by earliest of 3 dates meta query
  57. WP_Query() displaying past post / event
  58. WP Query Conditionally query meta and taxonomy
  59. Combining queries with different arguments per post type
  60. Ordering posts having multiple post-meta date fields
  61. How to get_queried_object on multiple objects?
  62. How to get the parent’s taxonomy?
  63. New WP_query in template not working with CPT+category on some pages
  64. Displaying a specific post in a wp query by post id
  65. Query current and future events, ordered by begin date
  66. WP_Query search posts by custom post type and custom taxonomy
  67. How to dynamically attach pictures to a carousel
  68. How to call a custom post type with WP_query
  69. How can I made custom taxonomies relationship?
  70. Pagination issue on category.php using custom post type query
  71. How to get all tags of a custom post type by id
  72. Limiting posts_join, where, etc to a specific WP_Query object?
  73. How to make WP_Query not to show irrelevant posts?
  74. Create an archive page for custom post type with custom taxonomy
  75. How to sort a WP_Query by a custom field AND ALSO filter by a different custom field
  76. Undefined $post in wp_query
  77. Get current user id
  78. Query for post and costom post_type in same category filtered by meta for post_type
  79. fetch custom post by meta key if key value is does not know
  80. List latest post out of 2 custom post types
  81. How to count other posts not having specific taxonomy terms?
  82. How to properly use Categories with Custom Post Types
  83. Displaying Portfolio Filter by Category Order (alphabetically)
  84. Custom Post Type Query W/Category Dropdown
  85. Pin posts to top of custom loop
  86. WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
  87. Query custom post type and custom field by URL parameters
  88. Custom Taxonomy – fields
  89. CPT Loop, include taxonomies and disclude others?
  90. Custom Post Type Query by user id
  91. CPT post doesnt shows tags and category on backend admin page
  92. Adding a nav menu for a custom post type
  93. How to use costum database table for custom post type
  94. date_query won’t accept day parameter, but will accept month and year for a custom post
  95. Custom Post ‘Post Per Page’ Crashing Page?
  96. Issue with permalinks for custom post type
  97. Paged within a custom content type template [duplicate]
  98. WordPress can only query up to 766
  99. loop through custom post-type with two meta_keys
  100. How to exclude certain portfolios from a loop