wp_query serialised array

As I commented, if the meta value is a serialized string of an array like array( 'Melbourne', 'Sydney' ), then 'value' => '"(Melbourne|Sydney)"', 'compare' => 'REGEXP' would work.

So there’s no need for a complex regular expression pattern, and your meta_query could look like so where $locations is an array of locations:

'meta_query' => array(
    array(
        'key'     => 'location',
        'value'   => '"(' . implode( '|', $locations ) . ')"',
        'compare' => 'REGEXP',
    ),
),

Related Posts:

  1. order by numeric value for meta value
  2. numberposts? showposts? posts_per_page?
  3. $GLOBALS[‘wp_the_query’] vs global $wp_query
  4. Some doubts about how the main query and the custom query works in this custom theme?
  5. Set Alias for meta_query arguments in get_posts()
  6. How can I use order_by to order by two meta_keys without excluding posts that don’t have those keys initialized?
  7. How to query only for products with status “in stock” in WooCommerce? [closed]
  8. WP_Query displaying ALL posts
  9. Does WordPress sanitize arguments to WP_Query?
  10. WP_Query meta_query where meta value ends in space
  11. Highlighting Sub topic in a post?
  12. wp_query for the first sticky, then display the rest of the posts excluding the first sticky
  13. How to combine tax_query and date_query in WordPress
  14. How to get any tag ID
  15. WP_Query with many meta_query arguments taking a long time to load
  16. Slow speed and high CPU usage for my code. How to improve it?
  17. Multiple queries on Home Page – page load/site speed issue
  18. Targeting specific pages in the loop
  19. WordPress custom archive page
  20. query attachments of parent page if attachments of current page are smaller than …
  21. Include Sticky Posts in Page Post Count for custom query
  22. Query sticky posts with thumbnails
  23. Show all parents and children in custom post type in right order
  24. Why is this coming back as null? Thats wrong. There is one post
  25. Retrieve featured image (thumbnail) url from multiple posts with one query
  26. WP_Query tax_query problem
  27. How to implement time filter to show random post 1 month for one category and 3 months for other categories
  28. Can you order posts from wp_query by two custom meta fields?
  29. Retreaving all images attached to current post
  30. wp_query() get_col error
  31. How to select posts from one category but exclude posts in another category?
  32. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  33. How can you get first post, last post and post count in a category?
  34. WP_query posts closest to todays date
  35. Setting get_queried_object
  36. Need wp_query to return all children and grandchildren
  37. How to use offset in WP_Query
  38. difference between like ‘%%%var%%’ and ‘%var%’
  39. WP Query Category Atribute Not Working
  40. new WP_Query to get max price meta value not working
  41. wp_query should show stickies first
  42. How to orderby multiple meta fields if some fields are empty
  43. WordPress custom post type with meta – how to retrieve with wp_query
  44. wordpress search word, “hello world” ===> ‘hello+world’ ===> ‘hello’, ‘world’
  45. Order by meta value (numeric value lower to higher)
  46. Wp_query calculate points
  47. WP Query – Outputting JSON and normal loop of posts
  48. Wp query show post by author name or post title or post content
  49. wordpress ajax relationship query
  50. get data match with extra field value using wp_query for custom post
  51. Admin Page Post Id wp_reset_postdata not working
  52. Multiple queries and performance – wp_query
  53. WP_Query for a taxonomy with different taxonomy types
  54. Append URL query to next post link in custom query
  55. How to compare a date in custom field with today’s date in custom WP_Query?
  56. Display single most recent post in category on every page of category archive
  57. Executing query_posts after wp_insert_post
  58. Shortcode for custom query not returning results when attributes are added
  59. wp_query is showing posts from other categories
  60. Get posts in taxonomy randomly
  61. Page navigation doesn’t seem to work when I add offset?
  62. it’s possible make a WP_Query with math operations?
  63. show posts with range meta key
  64. is_404() – where does this get set?
  65. wp_query on page template not working (Genesis framework)
  66. Max Posts and Memory Limit
  67. WordPress | WP_Query does not return anything with s=a
  68. WP_Query Pagination
  69. WP_Query orderby
  70. Using Ajax and WP_Query to load more posts on category page fails
  71. I have problems with the search query using multiple post types
  72. Different query result on local and server
  73. meta_query compare > not working
  74. 404 page on custom search pagination
  75. How can I show only last year posts in wordpress archive?
  76. WP_Query about meta_key and its array value
  77. Query string order by custom field
  78. Paging works correctly on local version, but not live?
  79. Change database image location for transportability
  80. Combine Tax Archive and Meta_Query in WP_Query
  81. Get posts by birthday
  82. How to add in WP_Query to every 3 posts displayed? [duplicate]
  83. Paginate nested query of child posts
  84. how to avoid reloading/refresh the page when displaying the post of wp_list_categories
  85. Pagination not working with WP_QUERY
  86. Get Current CPT taxonomy category in shortcode
  87. Display images with same specific value?
  88. Custom Content Slider stop duplicate
  89. Sort Posts with custom meta key by default which is currently set as optional
  90. wp_query pagination links producing 404
  91. How return normal search result using wp_ajax action for wordpress
  92. Custom post types loop on a page template
  93. Pagination problem with multiple loops on the same page
  94. Carousel slider with WP_Query to show 3 posts on each slide
  95. how to use transient method?
  96. WP_Query – meta fields numeric
  97. How to query posts from single post format on Genesis framework
  98. How to get all post_id and meta_value using meta_key in wp_postmeta table
  99. List categories using WP_Query
  100. WP Query – Show custom posts only if user contain some user meta