how to query for meta_value have array

No, you can’t do that via a query. You can request everything then manually filter out items via PHP, but that would be slow.

Instead, you need to address the root problem, that you’re storing serialised PHP data in a single field, rather than multiple fields, e.g. you should have an option1 meta key/value and an option2 meta key value pair etc

As a sidenote, if you’re wanting to use these to filter, perhaps you should be using a taxonomy instead of post meta

Related Posts:

  1. Does meta_value (array) work with ‘orderby’?
  2. How to only display posts whose meta_value field is not empty?
  3. Is it possible to orderby multiple meta_keys when using meta_value_num?
  4. Too slow when using both ‘tax_query’ and ‘meta_query’ both in WP_Query
  5. What kind of object type is WP_Query?
  6. How can I save an array from a random post sequence for later use?
  7. Getting an array out of WPQuery
  8. WP_Query with meta_value LIKE ‘something%’
  9. assign 2 $args to one wp_query
  10. Use Transient API to cache queries for all posts in all categories?
  11. Sorting meta_value as integer doesn’t work
  12. WP Meta Query for some meta (array) values
  13. meta_query with array as value
  14. Placing a div or img in between a post array using WP Query [closed]
  15. Show one post per author and limit query to 8 posts
  16. Add a default meta_value to new posts
  17. Ordering by meta_value AND date NOT WORKING with wp_query
  18. How add a custom posttype name using ACF field to a query post array
  19. How to use Meta Value Compare in WP_Query For Max and Min numbers
  20. Custom WP Query from meta_value stored as serialised array
  21. meta_query works locally but not on live server
  22. Ordering Posts Type A by Custom Fields of related Post Type B
  23. How can I get an array of all IDs from the current queried object?
  24. How can I pick a single post from the latest 3?
  25. WP Query for variable taxonomies
  26. Minimize database queries to user tables?
  27. Custom query for sidebar isn’t returning results
  28. Need wp_query to return all children and grandchildren
  29. (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
  30. Adding an array from a query string to a WP meta_query
  31. new WP_Query to get max price meta value not working
  32. Query multiple meta values
  33. Why isn’t my `meta_query` array functioning properly?
  34. How to orderby multiple meta fields if some fields are empty
  35. Weird orderby => post__in issue
  36. Meta_query on same meta key, with diffrenct values
  37. How to list custom fields as headers and list all pages sharing that custom field under it?
  38. How to extract specific post
  39. Meta Query relation “AND” then set array accordingly
  40. Query all posts if multiple meta key don’t exist
  41. Get posts by list of post IDs ordered by those IDs?
  42. Removing duplicate values between two wordpress queries
  43. Include current post into loop
  44. Combine results of multiple WP_Query to resemble single WP_Query
  45. How do I turn these values from MYSQL into an array
  46. search serialised meta_value for date value?
  47. Combine 2 arrays in a query parameter
  48. WP Query Meta Value – How To Identify Specific, Unique Values?
  49. How can I comment comma-separated array values?
  50. How do I add a relation parameter to my filter query?
  51. construct complex queries with WP User Query
  52. query post by author gender
  53. WP_Query with page_ids in arguments without a result
  54. Related Posts Excluding Certain Categories
  55. Show posts of an advanced search form
  56. Query using string from custom field as array value
  57. Multiple meta query from array
  58. Meta query with compare by more than 2 fields
  59. Category based on post id
  60. How to get specific string in explode array?
  61. How to avoid filling up an array each time I run a WP_query?
  62. Remove from array in WP_Query loop
  63. meta_query returning excluded result
  64. Order (by ASC) posts with meta_key so posts without values are last
  65. Combine relationship posts with existing wp_query
  66. Counting instances of words in the results of a post query
  67. Retrieve all custom field values of a specific custom field metakey as an array, inside WP_Query
  68. WP Query by 4 different taxonomies
  69. Trouble with serialized metadata
  70. What code to use in an array to call the current sub-category?
  71. WP_User_Query Orderby Not Working
  72. Loop through array of pages
  73. Repeat array inside array through while loop
  74. Sorting Posts by Taxonomy thats not within the query’s $args
  75. Gather same custom field values in one value in a select tag with wp_query
  76. Related Post by Tags Code
  77. date_query problem
  78. Order posts by more than one variable (meta_key and publish date AND time)
  79. WP_Query: Meta_Query with serialized value (or a workaround)
  80. Sorting Posts with meta value not working
  81. wp_query – Modify $query to include duplicate content
  82. Iterate through ID’s in loop
  83. How to get several fields from wp_query?
  84. Cannot order by in WP_Query
  85. How to sort a WP_Query array by post_name after an array_merge();
  86. Issue with WP_Query (need a array of selected ID’s)
  87. WordPress WP_Query Array Custom search via taxonomies
  88. Query to get all the posts of more than 2 meta_value having same meta_key?
  89. WP Query posts__in not working with array
  90. Sort Posts with custom meta key by default which is currently set as optional
  91. Dynamically name array in WordPress loop – add/get values
  92. Dynamically create array from page title
  93. Order by meta values
  94. WordPress Query Returning Every Post
  95. Creating Custom Query
  96. query_posts, oderby meta_value & print “future” posts
  97. Get posts by meta value except one post [closed]
  98. How do I have multiple metaqueries inside one wordpress query
  99. I want to place a post before all others from an ACF boleen field
  100. wp_query, calculate with two dates when ‘key’ is text format