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. Using meta query (‘meta_query’) with a search query (‘s’)
  6. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  7. Max length of meta_value
  8. ORDER BY custom field value
  9. Add custom fields to search
  10. Matching Serialized Arrays with meta_query
  11. Meta Query with AND & OR?
  12. get_pages sort alphabetically by meta value
  13. Trying to perform complex custom field query with order by set to field value
  14. Assign/update the custom field value for all posts
  15. Order by custom field date with ASC order
  16. WordPress Search Custom Meta Field Only
  17. Compare meta_query decimals not working right
  18. Ordering posts by anniversary using only day and month
  19. Loop through two different sets of custom fields
  20. How to break meta values into different items and avoid duplicates?
  21. Slow meta query with multi meta keys
  22. Using OR in WP_Query negates the “NOT EXISTS” compare
  23. How can I query on the year part of a complete date in a custom field?
  24. WP_query : meta_key with custom rule for specific value
  25. How can I combine meta_query queries?
  26. Difference between ‘LIKE’ and ‘IN’ in meta queries
  27. Sorting posts by multiple values, combined
  28. meta_value_num sort glitch
  29. WP_Query display next custom post from today’s date
  30. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  31. WP_Meta_Query causing long-running MySQL queries
  32. Sorting posts by custom fields in meta_query
  33. meta_query for a string inside a meta field containing a comma-separated list
  34. Order by custom field value not working for acf date field
  35. How to sort category by custom field value
  36. trim custom field text value and show (…)
  37. Complex WP_User_Query call fails on production server
  38. Query post order by post and desc not working
  39. Meta query with timestamp using WP_query
  40. Orderby custom field meta value ASC and then by date DESC
  41. How to wrap meta values seperated by comma in ? [closed]
  42. How to create a Custom Meta Box with Name/Value Admin User Input Fields?
  43. How to add a new meta key and assign timestamp to posts
  44. Get content from pages with same meta_key from Database
  45. Run a check for multiple meta key values
  46. Filter by custom field (meta_key) using JSON API
  47. WP 3.1 meta_query for multiple custom field values
  48. How do I have WP_Query match posts based on search parameter OR meta fields? (rather than search parameters AND meta fields)?
  49. Removing link ” from ” on meta_value in custom feilds
  50. Get posts with same meta value as current post
  51. Alter main archive, to show posts with meta as last
  52. Change order of posts
  53. Use meta_query to get title of associated post
  54. Ordering posts by custom field named “date” in backend
  55. get posts where a custom field contains a text
  56. WP Query – Is this correct?
  57. Avoiding ACF get_field and returning to core WordPress function
  58. pre_get_posts : only get posts by wp_usermeta value
  59. ORDER BY custom field value out of where clause
  60. comment meta_query for keys that aren’t yet set
  61. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  62. meta_value and meta_key filtering returning no posts [closed]
  63. IF Custom field value equals ZERO
  64. List custom field values ​​in alphabetical order without repetition
  65. ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
  66. Update post meta custom field using block editor
  67. How to add custom filed value after in wp post title
  68. change order of images attached to post
  69. Sortable Custom Columns not sorting correct
  70. Meta_query ‘compare’ => ‘LIKE’ not working?
  71. Diamond question mark in text after migrating content
  72. query_posts with meta_value
  73. tax query between operator like
  74. Show array of meta_value in Edit Post Coloum
  75. Best way to sort estates and query them (for rent? yes/no. contains office space? yes/no)?
  76. Is it possible to compare the current time with a custom “start” and “end date
  77. How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
  78. Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
  79. multiple meta_query and orderby question
  80. User query – getting values for custom meta keys/fields
  81. Set class if a meta value is set within post archive
  82. WP meta_query args not working in function
  83. Filtering posts by ACF meta query
  84. Why does my numeric meta query work only on one meta key and not the other?
  85. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  86. meta_query to check all custom fields
  87. 4 Unique Random Posts based on Custom Field Values
  88. Create custom query for search?
  89. Query Posts Via WordPress URL
  90. Custom Field: Display only if a specific key is selected outside the loop
  91. Meta_query not filtering posts
  92. Filter Query Post by Custom Fields(by date)
  93. Dynamic background image used in css after selector
  94. Saving multiple custom meta box fields
  95. get Custom field label (select/dropdown) on front end
  96. Can I count every article following extracted meta value?
  97. Best Practice for storing aggregate data by date or other criteria?
  98. Block Editor – Meta values not saved, meta changes to empty array on update
  99. Sort posts based on an acf field called fecha value return longtext ‘20240517’
  100. Query ‘orderby’ when there are multiple values for the same meta_key