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. How to only display posts whose meta_value field is not empty?
  5. Can wp_query return posts meta in a single request?
  6. order by numeric value for meta value
  7. How do I query for posts by partial meta key?
  8. Use REGEXP in WP_Query meta_query key
  9. WordPress retrieving meta data for all custom post types in list view
  10. Order by optional meta key?
  11. meta_query: using BETWEEN with floats and/or casting to DECIMAL
  12. Reduce or prevent calling of update_meta_cache
  13. Is there a way to extend WP_query so Custom Post Types can have properties?
  14. What is the most efficient way of querying posts based on visits and date for current day?
  15. Too slow when using both ‘tax_query’ and ‘meta_query’ both in WP_Query
  16. Getting attachments by meta value
  17. WP_Query displaying ALL posts
  18. What kind of object type is WP_Query?
  19. How can I save an array from a random post sequence for later use?
  20. meta_query where value is equal to given value
  21. Query Custom Meta Value with Increment
  22. WP-CLI How to generate a list of posts with corresponding meta values
  23. Getting an array out of WPQuery
  24. What is an efficient way to query based on post_meta?
  25. assign 2 $args to one wp_query
  26. WP_Query not working as expected for attachments and custom meta_query
  27. Use Transient API to cache queries for all posts in all categories?
  28. How to count post meta key values for all posts in database
  29. Group posts by meta_key
  30. How should I use posts_where to change meta_value from a string to integer?
  31. How can I create a WP_Query that returns posts where one meta_value
  32. WordPress altering my custom query, How to fix it?
  33. WP Query post meta value
  34. meta_query with array as value
  35. Would this post meta be better added to the post table rather than post_meta table
  36. Custom URl parameter
  37. query posts in functions.php and update a field
  38. Compile meta values from custom loop into array and then calculate sum total
  39. How to get sum of meta_values of a meta_key in wp_query according to conditions
  40. Placing a div or img in between a post array using WP Query [closed]
  41. how to fire join query with post_meta
  42. Show one post per author and limit query to 8 posts
  43. Best approach to create Hot and Trending sections
  44. WP_Query, custom sort and custom filter
  45. Order posts by meta value and Date
  46. Efficient way to update multiple post meta
  47. How add a custom posttype name using ACF field to a query post array
  48. How to make orderby ‘meta_value_num’ OPTIONAL?
  49. Query Posts depends on custom field inside repeater field using acf
  50. How can I get an array of all IDs from the current queried object?
  51. How can I pick a single post from the latest 3?
  52. Query post with meta_query where date is not in future
  53. WP Query for variable taxonomies
  54. Minimising Database Queries when using Advanced Custom Fields
  55. Get meta info related to current post
  56. Select from wp_post and multiple meta_value from wp_postmeta
  57. Pull post meta with post_query?
  58. Group WP_Query by meta_key date
  59. Minimize database queries to user tables?
  60. WP_query posts closest to todays date
  61. exclude posts with a specific custom field and value
  62. (Solved) WP_Query ($ args) -> How to sort letters and numbers within the same array
  63. Inserting serialized value into wp_postmeta using update_post_meta
  64. How to make Meta Query case sensitive?
  65. Performance when getting post meta for post retrieved by meta value
  66. Adding an array from a query string to a WP meta_query
  67. Get attachment by meta_key value
  68. Display custom field meta outside loop, site wide
  69. Using hook to use DISTINCT in a wp_query
  70. Fetch Record based on meta key dates
  71. Weird orderby => post__in issue
  72. Where to put meta Keys
  73. How to list custom fields as headers and list all pages sharing that custom field under it?
  74. how to make members list directory through wordpress post custom meta key.
  75. How do I query for posts by partial meta key?
  76. Large AND OR query timing out
  77. get_post_meta slowing down my page load (in a plugin)
  78. New WP_Query loop in admin causes problems
  79. echo a specific meta_key queried through a custom post
  80. How to increase load time of an archive/search page (WP_Query)
  81. Query all posts if multiple meta key don’t exist
  82. get_post_meta in WP_Query
  83. Get posts by list of post IDs ordered by those IDs?
  84. Which is faster wpdb & get_row or wp_query & ge_post_meta?
  85. Hide posts with meta key in WP_Query
  86. Removing duplicate values between two wordpress queries
  87. Include current post into loop
  88. Filter posts by comparing custom meta value against postdate
  89. WordPress query posts with multiple post_meta data
  90. Combine results of multiple WP_Query to resemble single WP_Query
  91. How do I turn these values from MYSQL into an array
  92. WP_Query – Accessing MetaValue from Query Result
  93. Does meta_value (array) work with ‘orderby’?
  94. How do I check if an article is popular this week?
  95. Combine 2 arrays in a query parameter
  96. Woocommerce: order posts by meta key
  97. How can I comment comma-separated array values?
  98. How do I add a relation parameter to my filter query?
  99. Order WP_Query results by meta key value in custom query
  100. construct complex queries with WP User Query