search serialised meta_value for date value?

Don’t serialize the search value, just use 'value' => '2011-09-16' 'compare' => 'LIKE'.

Otherwise you’re essentially looking for;

a:1:{i:0;s:10:"2011-09-16"}

Which of course doesn’t actually match anywhere in; 

a:2:{i:0;s:10:"2011-09-16";i:1;s:10:"2011-09-17";}

Related Posts:

  1. WP Meta Query for some meta (array) values
  2. Trouble with serialized metadata
  3. How to get several fields from wp_query?
  4. order by numeric value for meta value
  5. Reduce or prevent calling of update_meta_cache
  6. What is the most efficient way of querying posts based on visits and date for current day?
  7. Too slow when using both ‘tax_query’ and ‘meta_query’ both in WP_Query
  8. WP_Query displaying ALL posts
  9. How can I save an array from a random post sequence for later use?
  10. What is an efficient way to query based on post_meta?
  11. How to count post meta key values for all posts in database
  12. How should I use posts_where to change meta_value from a string to integer?
  13. How can I create a WP_Query that returns posts where one meta_value
  14. meta_query with array as value
  15. How to get sum of meta_values of a meta_key in wp_query according to conditions
  16. Best approach to create Hot and Trending sections
  17. Order posts by meta value and Date
  18. How add a custom posttype name using ACF field to a query post array
  19. How to make orderby ‘meta_value_num’ OPTIONAL?
  20. Query Posts depends on custom field inside repeater field using acf
  21. How can I get an array of all IDs from the current queried object?
  22. WP Query for variable taxonomies
  23. Get meta info related to current post
  24. Select from wp_post and multiple meta_value from wp_postmeta
  25. Pull post meta with post_query?
  26. Minimize database queries to user tables?
  27. WP_query posts closest to todays date
  28. exclude posts with a specific custom field and value
  29. (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
  30. How to make Meta Query case sensitive?
  31. Performance when getting post meta for post retrieved by meta value
  32. Get attachment by meta_key value
  33. Using hook to use DISTINCT in a wp_query
  34. Where to put meta Keys
  35. How to list custom fields as headers and list all pages sharing that custom field under it?
  36. How do I query for posts by partial meta key?
  37. Large AND OR query timing out
  38. get_post_meta slowing down my page load (in a plugin)
  39. New WP_Query loop in admin causes problems
  40. How to increase load time of an archive/search page (WP_Query)
  41. Query all posts if multiple meta key don’t exist
  42. get_post_meta in WP_Query
  43. Hide posts with meta key in WP_Query
  44. Removing duplicate values between two wordpress queries
  45. Include current post into loop
  46. WordPress query posts with multiple post_meta data
  47. Combine results of multiple WP_Query to resemble single WP_Query
  48. How do I turn these values from MYSQL into an array
  49. Does meta_value (array) work with ‘orderby’?
  50. How do I check if an article is popular this week?
  51. How do I add a relation parameter to my filter query?
  52. Nested array issue in meta_query
  53. Order a WP_Query by meta value where the value is an array
  54. WP_Query with page_ids in arguments without a result
  55. Display post meta conditionally based on it’s value
  56. Query using string from custom field as array value
  57. Sort by custom field that is an array?
  58. Category based on post id
  59. How to get specific string in explode array?
  60. WP_Query meta compare must include ALL array values
  61. meta_query returning excluded result
  62. wp query to use both author id and meta_query
  63. Counting instances of words in the results of a post query
  64. sanitize_post() is not sanitizing Post Object
  65. Sort by price wpdb
  66. WP Query by 4 different taxonomies
  67. show most viewed post
  68. Display posts from multiple value in meta separated by comma
  69. Custom filter from post meta
  70. Why can my filter query SOME metadata but not other metadata?
  71. update_post_meta performance in a loop woocommerce
  72. update_post_meta performance in a loop woocommerce
  73. How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
  74. I need query_posts() to order results first by a meta value and then by post ID
  75. Repeat array inside array through while loop
  76. Sorting Posts by Taxonomy thats not within the query’s $args
  77. Related Post by Tags Code
  78. I can’t get post based on its postmeta value and key
  79. Saving custom fields for WP_Query to retrieve
  80. date_query problem
  81. How to show all the associated posts with specific date of data metabox?
  82. WP_Query Posts by Metadata from Option Tree
  83. wp_query – Modify $query to include duplicate content
  84. Iterate through ID’s in loop
  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. WP Query to order posts by multiple meta fields
  88. Return a single custom post from multiple meta queries
  89. Custom Search Query – include only custom fields and title
  90. WP Query posts__in not working with array
  91. How to count post meta key values for all posts in database
  92. Sort Posts with custom meta key by default which is currently set as optional
  93. query by meta value then date and not empty meta value
  94. Dynamically create array from page title
  95. WordPress Query Returning Every Post
  96. wordpress sorting using array merge by price in ascending order but price with 0 must be show last
  97. Query posts by meta value and sort by another meta key
  98. I want to place a post before all others from an ACF boleen field
  99. wp_query, calculate with two dates when ‘key’ is text format
  100. Extend search query to search meta keys values based on search string
techhipbettruvabetnorabahisbahis forumutaraftarium24edusedusedusedueduseduseduedusedusedus