WP Query Meta Value – How To Identify Specific, Unique Values?

You are Storing multiple values into one single meta entry, instead of storing each value on its own meta entry (which would be the optimal approach).

But still you can make it work that way.

According to the docs, for the WP Query match operator you can use:

Possible values are ‘=’, ‘!=’, ‘>’, ‘>=’, ‘<‘, ‘<=’, ‘LIKE’, ‘NOT LIKE’, ‘IN’, ‘NOT IN’, ‘BETWEEN’, ‘NOT BETWEEN’, ‘EXISTS’

  • If you go with the = operator, you will not get your expected results since you are storing the club name as a substring.

  • If you go with the LIKE operator, you will get unwanted results if your Club Name is a part of another Club Name. As Cove and Coventry.

So a possible solution if you don’t want to store the names as individual entries would be to force your checks by adding a separator to your $clubname variable.

For example:

'meta_query' => array('relation' => 'OR',
   array('key'=> 'previous',
         'value' => $clubname.',',
         'compare' => 'LIKE',
        ),
   array('key'=> 'later',
         'value' => $clubname.',',
         'compare' => 'LIKE',
        ),
   )

But this will only work if all of your club names do have a comma after it. Including the last name in the list!

It won’t work with spaces because that would not detect the difference between Vauxhall Motors and Vauxhall Motors (London)

So, in this case, your meta value content should be:

“Whatever, something else, blablabla, Vauxhall Motors, other,”

But the real nice solution would be to have a meta field that contains the exact name, and then you can use the = with no issues.

Related Posts:

  1. Is it possible to orderby multiple meta_keys when using meta_value_num?
  2. Query multiple meta values
  3. Why isn’t my `meta_query` array functioning properly?
  4. How to orderby multiple meta fields if some fields are empty
  5. Meta_query on same meta key, with diffrenct values
  6. Meta Query relation “AND” then set array accordingly
  7. query post by author gender
  8. Meta query with compare by more than 2 fields
  9. Order (by ASC) posts with meta_key so posts without values are last
  10. WP_Query multiple value not working
  11. Get posts by meta value except one post [closed]
  12. How to only display posts whose meta_value field is not empty?
  13. WP Query Args – Title or Meta Value
  14. Meta query with string starting like pattern
  15. how to show posts that are missing a meta_value
  16. Does tax_query really beats meta_query in all situations?
  17. Query WooCommerce orders where meta data does not exist
  18. Execute a large WP_Query with many “AND” Meta_Queries?
  19. Query all posts where meta value is empty
  20. WP_Query min and max values
  21. querying with custom meta field with meta_query
  22. Order by two meta keys
  23. multiple meta key but get server load is very high
  24. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  25. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  26. Use meta_query to display events by date in custom field
  27. Meta-value query
  28. Meta query field order together with post_date order causes posts without the meta field to be unordered
  29. How to show recent and upcoming birthdays using meta_query
  30. pre_get_posts filter meta_query without conflicting existing meta_query
  31. Undefined property: WP_Query::$post
  32. Programmatically set ‘meta_query’ for filter
  33. Using WP_Query and WP_Meta_Query Outside of WordPress
  34. If two first numbers exist in wp_meta_query value
  35. WP_Query meta_query >= date
  36. Extending woocommerce admin product search
  37. Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?
  38. Tax query clause inside a meta query clause?
  39. Custom query for sidebar isn’t returning results
  40. Adding an array from a query string to a WP meta_query
  41. Optional Meta Query
  42. Query by multiple meta elements not seeming to work – wordpress is timing out
  43. How do I make a meta_query OR relation work? [closed]
  44. Can we return all category (not post) with Custom Query Filter? [closed]
  45. How does one perform a sub query with different post types
  46. how to make members list directory through wordpress post custom meta key.
  47. WP_Query with meta_query dosen’t return results
  48. meta_compare not comparing whole integer
  49. How to provide meta_key array to wp_query?
  50. meta queries do ‘either/or’ checks
  51. WP Query ordering on a meta field for posts with a date in the future not ordering by datetime
  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. Save queried result into database
  64. WP Query – grouping posts by same meta key, adding together values from another key
  65. Woocommerce Get Orders By Meta Value
  66. meta_query is overriding default search
  67. Multiple WP_Query args combinations according to post type
  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. Order by meta values
  94. Query string form $_GET[‘value’] is not working as meta value in wp_query
  95. Can’t figure out query logic
  96. WP_Query orderby not working on custom post_type
  97. 294 Queries on Mainpage of WordPress
  98. How do I have multiple metaqueries inside one wordpress query
  99. WP query with multiple custom meta not respecting orderby
  100. Display only posts with thumbnails