WordPress custom loop filter by meta_key and value with serialize data

philosophical opinion, people that store serialized data do not mean it to be used in searches.

If you need to search in that data, you should hook on the save_post hook (or whatever is relevant) and store whatever you need in a different meta in a way that can be used in search.

Side notes:

  1. Searching in meta is not scalable
  2. LIKE have horrible performance, if you get into the point of using it you should ask yourself where did you go wrong 😉

Related Posts:

  1. Multiple orderby values in WP_Query
  2. Search multiple custom fields by using meta_query
  3. WP_Query orderby custom field then post_date in one query
  4. how to filter by last name for custom post
  5. Filtering a WP_Query meta_query by numeric values isn’t working
  6. Sorting a query by custom field date
  7. How can I generate a RSS feed based on a custom WP_Query?
  8. Display Custom Post Type Fields
  9. Search Custom Post Type with all meta attached?
  10. How to sort CPT by custom meta value (date), and return posts month by month
  11. WP_Query on custom post type not displaying, multiple loops & get_template_part
  12. Using new WP_Query in shortcode in a custom field causes the main post content to not display
  13. WordPress query by multiple Custom fields and order by date
  14. Comparing timestamps in meta query doesn’t work
  15. Display two post types ordered by two custom fields
  16. Get post info inside modal window?
  17. Having trouble with custom date field for CPT query (WordPress)
  18. Display posts if a custom field value is equal to another custom field value
  19. Sort by two dates. Default entry date and custom field if present
  20. Conditional to modify query results
  21. Filtering by Post Meta Custom Fields – Performance
  22. wp_query to find posts by year and month
  23. WP Query—Relationship between two custom post types and their fields
  24. Get all Posts If has same custom field values in Posts
  25. Custom Post type and Custom Field WP_Query
  26. Including Custom Meta with posts_where query
  27. WP_Query: include custom post type only with specific meta value
  28. WP_Query orderby modified to include custom meta changes
  29. Returning a list of custom post types excluding those without a specific meta_value
  30. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  31. wp_query check if integer exists in custom field’s array
  32. How can I get the number of custom post type posts that have a specific attachment image set?
  33. Problem querying Custom post type by custom fields
  34. Orderby CPT custom fields not working
  35. WP_Query order by custom field, then randomly order some of results
  36. Query custom post type with ACF Date
  37. Including metaboxes from custom post types in global search — continued
  38. Get Posts by multiple custom fields is not working
  39. Order Custom Post Type by Custom Field Value
  40. First custom field value (out of several) displayed twice after query
  41. Possible to filter custom post type with multiple meta data?
  42. Query based on custom fields start and end date
  43. DIsplaying URL of custom field in last post of certain taxonomy && post type
  44. WP Query ‘posts_per_page’
  45. Display post from a date range from custom field
  46. post_per_page ignored in WP_Query
  47. How to get specific post meta by title or id
  48. Getting a custom post’s custom field based on another custom post’s custom field select
  49. WP_Query orderby not work with meta_key
  50. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  51. Display custom post type for specific user
  52. Custom Post type loop with ACF not displaying properly
  53. Group by custom field value (start and end times)
  54. Cache issue with WP_Query and custom field filtering
  55. How do I list a custom field and custom taxonomies for each result in a loop?
  56. WP query_posts group by meta field related
  57. Custom Form / Search with Custom Post Type Data
  58. Create if else for post types in WP_Query ‘post__in’ values
  59. WP Query from two Custom Post type fields as statement
  60. Alike Shortcode using in Custom Shortcode
  61. Query custom post type that has a serialized relational advanced custom field value
  62. WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
  63. WP_Query get always custom post_type for first
  64. Sort custom post column by generated value?
  65. How can I query and sort custom-post type using WP_Query
  66. Filter posts by their related field’s custom field
  67. How can I fetch all the dates from custom fields from various different custom post types and show / list them at one place in ascending order?
  68. Query custom post type and custom field by URL parameters
  69. Custom meta fields not showing up in WP_Response Object via custom endpoint
  70. Query a Custom Post Type using SELECT that has ACF fields to compare dates
  71. meta query multiple values for the same key
  72. Sort custom post archives by a meta value from a different custom post type?
  73. Custom post types – meta_query: search lesson which starts sooner
  74. Post Filtered by Custom Field Value
  75. Filter custom WP_Query by first letter of a custom field – hopefully using Search and Filter Pro?
  76. sorting in wp query based on custom field value
  77. Meta_Query refuses to return results
  78. WordPress loop add heading before first of type
  79. How to make a shortcode for my WP_Query Loop? [duplicate]
  80. Error in WP Query. If variable is empty it is displaying previous post value
  81. Query events post type after current date and timezone
  82. Calling specific page with wp query
  83. How to stop wp_query searching pages as well as the specified CPT
  84. Selecting posts older than the current Unix epoch timestamp
  85. WP_Query and two custom fields returns no posts
  86. WP_Query get posts where post_name is empty
  87. Storing/querying custom date data
  88. Query recent posts by author
  89. 404 on Pages for Custom Post Type & Query_Posts
  90. Querying meta values within an array
  91. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  92. Filter Custom post type by another Custom post type
  93. Show Posts in Vertical Tabs with Scrollbar
  94. How to show all posts of specific custom post type with their custom fields values?
  95. querying to custom field over ACF REST API
  96. Display ACF object field data using Elementor Custom Query
  97. WordPress custom field sorting, weird behavior: the latest post is at the end
  98. Sort CPT by taxonomy AND THEN by custom field
  99. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?
  100. Query order by a numeric ACF field
tech