Can serialized arrays in DB be matched against serialized arrays with meta_query?

The one dirty option is using LIKE comparison in meta query request. It will just treat serialized value as string to make substring match against. It won’t be my first (or second) approach to rely on, but in some cases I had to do it like this.

Non-unique meta keys are a little tricky to work with, but they are much better way to store stuff you want to query by.

Related Posts:

  1. WP_Query – Order results by meta value
  2. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  3. Filter WP_Query for posts having a certain meta-value
  4. Can I query custom meta data through WP_Query
  5. Meta Query with AND & OR?
  6. How do I search an array stored in a custom-field using WP_Query?
  7. How do I order by multiple custom fields using wp_query?
  8. Trying to perform complex custom field query with order by set to field value
  9. Query meta field using between
  10. Order Posts by Closest Numeric Values
  11. 2 orderby in wp_query with 2 custom fields
  12. How to get a meta value from all post
  13. Compare meta_query decimals not working right
  14. WP_Query multiple use of relation and/or
  15. Query Problem – Show posts within category ‘x’ that have a custom field between ‘y’ and ‘z’
  16. Using OR in WP_Query negates the “NOT EXISTS” compare
  17. WP_query : meta_key with custom rule for specific value
  18. How can I combine meta_query queries?
  19. How to filter a dd/mm/yyyy date from a custom field in a query
  20. Using WP Query to search by multiple meta fields
  21. Difference between ‘LIKE’ and ‘IN’ in meta queries
  22. Compare WP Custom Field date
  23. Sort by posts that have a featured image?
  24. WP_Query display next custom post from today’s date
  25. Order by value in serialized custom field
  26. $wp_query meta_key naming issue [closed]
  27. Author Page Custom Query WHERE author OR [post meta value] OR [post meta value]
  28. Meta_query and numeric comparison [closed]
  29. Adding Custom Fields to Search
  30. Upcoming Event: How do I sort database by custom date field, but ignore past dates?
  31. Any way to include custom fields in WP_Query results?
  32. Multiple relationships in a query
  33. WP Query Returning All Posts
  34. How do I use wp_query for WordPress search?
  35. Meta query with timestamp using WP_query
  36. Conditional custom field query
  37. Order query by meta_value with multiple custom fields
  38. Auto Populate Custom Field with Complex Value That Increase by One?
  39. Custom WP_Query for WordPress Search Results with meta_query
  40. Meta Query And/Or
  41. How to combine custom fields to make one order-able value
  42. Passing meta_box string to post__in?
  43. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  44. meta_value and meta_key filtering returning no posts [closed]
  45. Select custom posts by meta_value and sort by a different meta value
  46. Can’t query by meta_key
  47. Adding custom field and querying from post table
  48. Meta query relation ‘OR’ not working as expected
  49. The best way to collision check in WP
  50. WP_query multiple custom fields not working
  51. Custom Query Fields – Altering Meta Value
  52. How to query for posts with either one or another custom field
  53. Multiple Custom Field Query
  54. How to update custom field of a posts in a particular category
  55. How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
  56. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  57. WP Query multiple select form – meta_query help
  58. How to Order Posts by Custom Fields?
  59. WP_Query based on multiple metadata comparisons
  60. Complex WP_Query Using Post Date And Post Meta
  61. Display posts where date field matches current month?
  62. Show posts containing or not custom field
  63. Display agents (custom post type) alphabetically, except one who always shows last
  64. Query posts by Custom Meta (checkbox) & Genesis Grid Loop
  65. Advanced Custom Fields: how do I check to see if a value is set in an field? [closed]
  66. Add filter menu to admin list of posts (of custom type) to filter posts by custom field values
  67. getting all values for a custom field key (cross-post)
  68. How to add a custom field in the advanced menu properties?
  69. Custom query with orderby meta_value of custom field
  70. How to filter post listing (in WP dashboard posts listing) using a custom field (search functionality)?
  71. Using meta query (‘meta_query’) with a search query (‘s’)
  72. Can I exclude a post by meta key using pre_get_posts function?
  73. Add validation and error handling when saving custom fields?
  74. Can wp_query return posts meta in a single request?
  75. Multiple orderby values in WP_Query
  76. Show Custom Fields in Quick Edit
  77. Where are custom field values stored in the database
  78. Validating Custom Meta Box Values & Required Fields
  79. Max length of meta_value
  80. Add custom fields to wp native gallery settings
  81. How to fix missing custom fields after upgrading to WordPress 4.8.1?
  82. How to enable custom fields for pages (if not a bad practice)?
  83. How can I add extra attribute in the ‘Page Attribute’ section in wp-admin for pages?
  84. Is there a way to set default custom fields when creating a post?
  85. Custom post meta field effect on the performance on the post
  86. How to get custom post meta using REST API
  87. Custom field/meta populated by dropdown of existing posts?
  88. Difference between meta keys with _ and without _ [duplicate]
  89. Filter by one custom field, order by another?
  90. Is there any action filter/hook for validating a custom field before publishing the post?
  91. Remove Dimension from wp_get_attachment_image
  92. Orderby meta_value only returns posts that have existing meta_key
  93. Underscores in custom fields
  94. What is the index [0] for on post meta fields?
  95. What is “meta_input” parameter in wp_insert_post() used for?
  96. Meta query with string starting like pattern
  97. Query Posts or Get Posts by custom fields, possible?
  98. How to enable revisions for post meta data?
  99. compare meta_query in get_posts arguments
  100. Sortable Custom Columns in User Panel (users.php)?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)