get posts based on non-single metadata

You are correct, this is not possible for serialised data. There are some hacks to try and get around this by searching for individual parts of the serialised string, but those throw up lots of false positives and can’t be sorted.

Generally, it’s an anti-pattern to store structured data inside a single meta value, and you can’t query the internal data in a meta_query field. If you absolutely must store it, store it as JSON, but keep in mind you can’t query or perform logic on the contents. ( serialised PHP values also open you up to object deserialisation attacks, and break when naive search replace queries are ran on the database if the length changes )

The solution here is to separate it out into individual atomic post meta, at least 5, do the sorting in PHP/JS,or to create child post types to represent your events so that you can use the standard date time columns

Related Posts:

  1. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  2. Making WP_Query limit results by date before today where date is a meta_query
  3. Create Shortcode shows only posts with custom_field meta
  4. WP Query Args – search by meta_key or title
  5. SQL query based on two different custom field values
  6. Using meta query (‘meta_query’) with a search query (‘s’)
  7. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  8. Max length of meta_value
  9. ORDER BY custom field value
  10. Can I query custom meta data through WP_Query
  11. Add custom fields to search
  12. Matching Serialized Arrays with meta_query
  13. Meta Query with AND & OR?
  14. How can I display all values of a custom field from posts with a certain value of another custom field or from certain post types?
  15. get_pages sort alphabetically by meta value
  16. Trying to perform complex custom field query with order by set to field value
  17. Is there a way to do multiple ordering on a multiple meta_query?
  18. Assign/update the custom field value for all posts
  19. Order by custom field date with ASC order
  20. WordPress Search Custom Meta Field Only
  21. Compare meta_query decimals not working right
  22. Ordering posts by anniversary using only day and month
  23. Calling Specific Pages with wp query Part II
  24. Loop through two different sets of custom fields
  25. How to break meta values into different items and avoid duplicates?
  26. Slow meta query with multi meta keys
  27. Using OR in WP_Query negates the “NOT EXISTS” compare
  28. How can I query on the year part of a complete date in a custom field?
  29. WP_query : meta_key with custom rule for specific value
  30. How can I combine meta_query queries?
  31. Displaying posts with only upcoming dates according their custom field date value
  32. Difference between ‘LIKE’ and ‘IN’ in meta queries
  33. Sorting posts by multiple values, combined
  34. meta_value_num sort glitch
  35. WP_Query display next custom post from today’s date
  36. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  37. WP_Meta_Query causing long-running MySQL queries
  38. Sorting posts by custom fields in meta_query
  39. meta_query for a string inside a meta field containing a comma-separated list
  40. Order by custom field value not working for acf date field
  41. How to sort category by custom field value
  42. trim custom field text value and show (…)
  43. Complex WP_User_Query call fails on production server
  44. Query post order by post and desc not working
  45. Meta query with timestamp using WP_query
  46. Orderby custom field meta value ASC and then by date DESC
  47. How to wrap meta values seperated by comma in ? [closed]
  48. How to create a Custom Meta Box with Name/Value Admin User Input Fields?
  49. How make a custom search on backend in WordPress without plugin?
  50. How to add a new meta key and assign timestamp to posts
  51. Get content from pages with same meta_key from Database
  52. Run a check for multiple meta key values
  53. Filter by custom field (meta_key) using JSON API
  54. WP 3.1 meta_query for multiple custom field values
  55. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  56. Removing link ” from ” on meta_value in custom feilds
  57. Get posts with same meta value as current post
  58. Alter main archive, to show posts with meta as last
  59. Meta Query returns wrong number of posts
  60. Sort alphabetically by custom field
  61. Change order of posts
  62. Meta Query And/Or
  63. Use meta_query to get title of associated post
  64. Meta query with multiple custom fields for archives page ordering problem
  65. filter custom field values $min $max
  66. Ordering posts by custom field named “date” in backend
  67. Get Data From wp_sitemeta for Multisite network
  68. Unique meta_key with array value vs repeated meta_key with single values
  69. get posts where a custom field contains a text
  70. WP Query – Is this correct?
  71. How can I do a variable for meta_query?
  72. Avoiding ACF get_field and returning to core WordPress function
  73. pre_get_posts : only get posts by wp_usermeta value
  74. ORDER BY custom field value out of where clause
  75. comment meta_query for keys that aren’t yet set
  76. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  77. meta_value and meta_key filtering returning no posts [closed]
  78. IF Custom field value equals ZERO
  79. List custom field values ​​in alphabetical order without repetition
  80. ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
  81. How to update a custom field in all posts with the value of another custom field in the same post?
  82. Update post meta custom field using block editor
  83. How to add custom filed value after in wp post title
  84. change order of images attached to post
  85. Sortable Custom Columns not sorting correct
  86. Meta_query ‘compare’ => ‘LIKE’ not working?
  87. Diamond question mark in text after migrating content
  88. query_posts with meta_value
  89. tax query between operator like
  90. Show array of meta_value in Edit Post Coloum
  91. Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?
  92. Is it possible to compare the current time with a custom “start” and “end date
  93. How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
  94. Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
  95. multiple meta_query and orderby question
  96. User query – getting values for custom meta keys/fields
  97. Woocommerce products search with custom fields
  98. How to save multiple values with same meta_key, each value linked to another tag id
  99. How to improve my non-unique metadata MySQL entries?
  100. Set class if a meta value is set within post archive
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)