Meta query with JSON value

That’s not json. You can’t put a semi-colon inside a javaScript Object like that.

That’s serialized-data. If you return that string & then call unserialize on it & then var_dump you can see what’s inside.

Also, see fuxia♦’s Answer Here for more info.

& to Maikal’s credit, you can use a meta_query in this situation, but you have to use the correct syntax…

I believe, it’s: 

'compare' => 'LIKE', 
'value' => '"2"'

& Darren Felton’s Answer Here seems to verify that

Related Posts:

  1. WP Query Args – Title or Meta Value
  2. Meta query with string starting like pattern
  3. how to show posts that are missing a meta_value
  4. Does tax_query really beats meta_query in all situations?
  5. Query WooCommerce orders where meta data does not exist
  6. Execute a large WP_Query with many “AND” Meta_Queries?
  7. Query all posts where meta value is empty
  8. WP_Query min and max values
  9. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  10. querying with custom meta field with meta_query
  11. Order by two meta keys
  12. multiple meta key but get server load is very high
  13. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  14. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  15. Use meta_query to display events by date in custom field
  16. Meta-value query
  17. Meta query field order together with post_date order causes posts without the meta field to be unordered
  18. How to show recent and upcoming birthdays using meta_query
  19. pre_get_posts filter meta_query without conflicting existing meta_query
  20. Undefined property: WP_Query::$post
  21. Programmatically set ‘meta_query’ for filter
  22. Using WP_Query and WP_Meta_Query Outside of WordPress
  23. If two first numbers exist in wp_meta_query value
  24. WP_Query on custom field and order results
  25. pre_get_posts order by not working
  26. WP_Query filter and order by meta ordering by wrong joined table
  27. Tax query clause inside a meta query clause?
  28. What is the random string I am seeing when I use get_query_var?
  29. Optional Meta Query
  30. How do I make a meta_query OR relation work? [closed]
  31. meta_query in WP_Query value is not accepting array
  32. Meta_query on same meta key, with diffrenct values
  33. Can we return all category (not post) with Custom Query Filter? [closed]
  34. Extend product search with meta in WooCommerce
  35. how to make members list directory through wordpress post custom meta key.
  36. get posts by meta_key from inside key of post meta
  37. Help optimizing slow WP_Query with meta_query
  38. meta_value_num not ordering all items
  39. Meta Queries – should nesting work after WP 4.1?
  40. Filter and Order by Multiple Custom Meta Values
  41. Meta Query relation “AND” then set array accordingly
  42. 2 weeks ago from meta query meta value
  43. WP_Query with meta_query dosen’t return results
  44. Query with meta_query and tax_query together not working properly
  45. Array as ‘key’ in WP_Query
  46. Is it possible to query a custom field where the value is between two fields?
  47. Filter posts by comparing custom meta value against postdate
  48. How to provide meta_key array to wp_query?
  49. Searching for meta_key returns 0 posts
  50. meta_query fails to compare on values containing apostrophes
  51. How to set up hierarchical relationships without using plugins / meta query
  52. Meta query compare for ID’s greater than specific ID
  53. Is it possible to add relation between meta_query and tax_query?
  54. add_query_arg to compare and display events from a certain date
  55. Show single posts date, in a page of posts
  56. WP_Query Class custom field parameters
  57. WP_Query not returning correct result with meta_query parameter
  58. meta_query where the meta value is not the post title
  59. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  60. Query on meta values and post title
  61. How do i create a custom post query when the meta value is an array?
  62. meta_query with meta values as serialize arrays
  63. WP Query – grouping posts by same meta key, adding together values from another key
  64. Woocommerce Get Orders By Meta Value
  65. meta_query is overriding default search
  66. Multiple WP_Query args combinations according to post type
  67. WP_Query multiple value not working
  68. How to do WP_User_Query for Nested Array value Inside Nested Array field
  69. Query for current post
  70. Custom query to retrieve oldest post and retrieve others with date interval
  71. WP_User_Query Orderby Not Working
  72. Unusual high query of user meta data
  73. Very slow query generated getting meta data from posts
  74. WordPress Query optimaization for slow query
  75. How to filter on placeholder image
  76. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  77. Meta query doesn’t remove placeholder escape before query
  78. WP Query Meta Query
  79. Query custom meta value – post view and date meta
  80. What is the best way to reset a search on a meta_key / meta_value?
  81. How can I modify standard search query to include also ACF custom fields values?
  82. Custom WP_query and integrating into theme file
  83. WP_Query – show posts where meta value and user_email match
  84. WP Meta Query at depth 2
  85. Best way to Order Post in Home without a plugin
  86. WP_Query using meta_query with LIKE doesn’t return what it should
  87. Is there any difference between below WP_Query code snippets?
  88. Return a single custom post from multiple meta queries
  89. Sorting: custom query with orderby meta_value_num THEN by title
  90. query post based on comparison
  91. Including ‘cat’ => $cat breaks meta_query
  92. meta_query compare not doing what I want it to do
  93. Query string form $_GET[‘value’] is not working as meta value in wp_query
  94. Can’t figure out query logic
  95. WP_Query orderby not working on custom post_type
  96. 294 Queries on Mainpage of WordPress
  97. How to get all post_id and meta_value using meta_key in wp_postmeta table
  98. WP Query – Show custom posts only if user contain some user meta
  99. How do I subquery with custom meta fields?
  100. Showing Counts on Comment List with Custom Query