How to query for posts with either one or another custom field

Your example is a bit hard to understand, as it seems to query for meta_values of X,Y,Z,AB,ID,IA. I hope you can still make sense of the below posted code:

// query posts that have on of the custom values for the custom meta key 'my_key' 
// and/or one of the custom meta values for the meta key 'your_key'
$posts = get_posts( array(
     'post_type' => 'my_post_type'
    ,'meta_query' => array(
         array(
             'key' => 'my_key'
            ,'value' => array( 'AB', 'ID', 'IA' )
            ,'compare' => 'IN'
         )
        ,array(
             'key' => 'your_key'
            ,'value' => array( 'AB', 'ID', 'IA' )
            ,'compare' => 'IN'
     )
) );

Other comparison values would be 'LIKE', 'NOT LIKE', 'NOT IN', 'BETWEEN', 'NOT BETWEEN' where the later twos are reserved for numeric comparison and need an extra meta key/value pair: 'type' => 'numeric'.

Related Posts:

  1. Meta Query with AND & OR?
  2. Upcoming Event: How do I sort database by custom date field, but ignore past dates?
  3. Conditional custom field query
  4. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  5. The best way to collision check in WP
  6. Complex WP_Query Using Post Date And Post Meta
  7. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  8. Filter WP_Query for posts having a certain meta-value
  9. How to rename a custom field?
  10. How can I make wp-pagenavi work on a custom query built upon a form submission? [closed]
  11. How do I search an array stored in a custom-field using WP_Query?
  12. How do I order by multiple custom fields using wp_query?
  13. Trying to perform complex custom field query with order by set to field value
  14. Query meta field using between
  15. Order Posts by Closest Numeric Values
  16. 2 orderby in wp_query with 2 custom fields
  17. Can serialized arrays in DB be matched against serialized arrays with meta_query?
  18. How to get a meta value from all post
  19. Compare meta_query decimals not working right
  20. WP_Query multiple use of relation and/or
  21. Query Problem – Show posts within category ‘x’ that have a custom field between ‘y’ and ‘z’
  22. Comparing timestamps in meta query doesn’t work
  23. Display two post types ordered by two custom fields
  24. Using OR in WP_Query negates the “NOT EXISTS” compare
  25. Having trouble with custom date field for CPT query (WordPress)
  26. Using WP Query to search by multiple meta fields
  27. Difference between ‘LIKE’ and ‘IN’ in meta queries
  28. Plugin similar to Taxonomy Drill-Down for custom fields?
  29. Compare WP Custom Field date
  30. Sort by posts that have a featured image?
  31. WP_Query display next custom post from today’s date
  32. Order by value in serialized custom field
  33. $wp_query meta_key naming issue [closed]
  34. Author Page Custom Query WHERE author OR [post meta value] OR [post meta value]
  35. Meta_query and numeric comparison [closed]
  36. Conditional to modify query results
  37. Count how many posts have a custom field set
  38. Any way to include custom fields in WP_Query results?
  39. sort search results by custom fields using dropdown
  40. Multiple relationships in a query
  41. Loop to display random posts only if a custom field matches category
  42. WP Query Returning All Posts
  43. How do I use wp_query for WordPress search?
  44. Order query by meta_value with multiple custom fields
  45. Display only past events on that page using Visual Composer Grid Bulider
  46. Custom Field Create Bulk via SQL Query
  47. Create Pop-Up Box with Custom Field Content Inside the Loop
  48. Auto Populate Custom Field with Complex Value That Increase by One?
  49. query usermeta from custom field
  50. Is there any way to get all meta and standard columns for any WordPress object after searching based on meta key and value
  51. Order RSS content by an advanced custom field value
  52. Order by empty custom field
  53. Alter main archive, to show posts with meta as last
  54. Custom WP_Query for WordPress Search Results with meta_query
  55. Meta Query And/Or
  56. How to combine custom fields to make one order-able value
  57. Trying to reorder posts by custom field
  58. Limits, not all post are showen when querying for posts by view count
  59. Get post ids sorted by meta_key
  60. querying a custom field
  61. pre_get_posts : only get posts by wp_usermeta value
  62. meta_value and meta_key filtering returning no posts [closed]
  63. Select custom posts by meta_value and sort by a different meta value
  64. Adding custom field and querying from post table
  65. List custom queried terms in the edit-tags.php?taxonomy page
  66. Loop through incrementing custom fields
  67. WP_query multiple custom fields not working
  68. WP_Query () using taxonomy, custom post types
  69. Multiple Custom Field Query
  70. Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?
  71. Get array of posts based on custom field values
  72. How to update custom field of a posts in a particular category
  73. Searching with Multiple (Parallel) Criteria on Custom Fields?
  74. How to query posts by month based on date custom field?
  75. How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
  76. Custom Field Date Problem
  77. Query multiple post types, but different order for each
  78. Compare ACF date field (if exists) and post date and order DESC
  79. Problem with revisions only returning four results
  80. WP Query from two Custom Post type fields as statement
  81. Dynamically populate query source in Elementor post widget
  82. WP_Query not ordering correctly
  83. Query against multiple locations within single custom post type post
  84. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  85. searching by keywords in post’s metas or pagination links problem
  86. Query by meta value (add a dropdown of all values)
  87. select user with all meta field and field value. I am use Below Query for this ,So any of know another way to fast query instead of below query?
  88. WP Query multiple select form – meta_query help
  89. How to Order Posts by Custom Fields?
  90. query specific posts according their custom fields, using sql SELECT
  91. Meta_query not filtering posts
  92. WP_Query based on multiple metadata comparisons
  93. Get multiple posts with some custom fields efficient
  94. How to add a prefix to existing custom fields over MYSQL query?
  95. Display posts where date field matches current month?
  96. How to check if custom field exists in this widget query
  97. Only show content slideshow if “slideshow” custom field exists
  98. Display agents (custom post type) alphabetically, except one who always shows last
  99. Filter Custom post type by another Custom post type
  100. Query posts by Custom Meta (checkbox) & Genesis Grid Loop
techhipbettruvabetnorabahisbahis forumutaraftarium24eduedueduseduedueduseduedusedusedu