WP_Query meta_query where meta value ends in space

Note sure how your structure is, but here’s one way, using RLIKE comparison and a space character class:

array(
    'key'     => '_address_postcode',
    'value'   => '^SC1[[:space:]]',    // Starts with 'SC1 '  
    'compare' => 'RLIKE'
)

Maybe you should consider adjusting the meta values, as suggested by @cybmeta?

But note that meta queries can be slow, so alternatives might be better here (e.g. as a custom taxonomy?).

Related Posts:

  1. meta_query with meta values as serialize arrays
  2. Use REGEXP in WP_Query meta_query key
  3. compare meta_query in get_posts arguments
  4. Display products from specific category in shop page
  5. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  6. Getting attachments by meta value
  7. Nested query inside Logical operator OR not working in meta_query
  8. What is an efficient way to query based on post_meta?
  9. WP_Query not working as expected for attachments and custom meta_query
  10. How do I create my own nested meta_query using posts_where / posts_join?
  11. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  12. How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
  13. Exclude post on loop by multiple meta key value
  14. How to query ‘posts_per_page’ to display a different blog posts index template?
  15. Order By Multiple Meta Fields
  16. Advanced WP Query hogs the SQL server
  17. Order posts by meta value and Date
  18. Query sticky posts with thumbnails
  19. How to get user_id from wordpress database inside ajax function?
  20. Meta query with order by another custom field
  21. WP_Query with multiple meta fields filter?
  22. How to combine meta_query and post__in in WP_Query
  23. How to orderby meta_value_num with dollar ($) sign
  24. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  25. Single meta_query query using OR instead of AND in request’s WHERE statement
  26. Meta Query Array Error 500
  27. How to do meta_query for attachments?
  28. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  29. Why isn’t my `meta_query` array functioning properly?
  30. Overwrite YoastSEO meta-tags with another page’s [closed]
  31. How to orderby multiple meta fields if some fields are empty
  32. Fetch Record based on meta key dates
  33. Suggestions on making this query/code more performant
  34. Order by meta value (numeric value lower to higher)
  35. Large AND OR query timing out
  36. WP_Query with different postmeta filter for each categories
  37. meta_query not working as expected
  38. Slow WP_Query with ‘OR’ on meta_query
  39. How to filter a query by multiple meta keys and order by other meta keys
  40. Query posts with “non set” meta value
  41. Ordering a mysql style datetime stamp with meta_query
  42. Wp_query with 2 meta keys and array of meta values
  43. Advanced WP_Query with meta_query, orderby?
  44. meta_query: check if number exists
  45. Event with multiple dates, display events chronologically
  46. Issues with search after added meta_query
  47. Display posts with specific value first in query
  48. WP_Query: apply an SQL function to meta fileld value
  49. How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
  50. How to create dynamic value in WP_Query meta_query
  51. query post by author gender
  52. How do I add an item to the WP admin menu?
  53. Multiple meta query from array
  54. WP Query / Meta Query [duplicate]
  55. Query posts by searching for a string in a meta field
  56. WP_Query with 4 post meta field arguments gives 500 internal server error
  57. Use have_posts() with array of post results retrieved by $wpdb->get_results
  58. Query multiple post types, but different order for each
  59. How to add date_query to meta_query array
  60. Order by the first array within a meta_query
  61. Query ACF relationship field – Comparator IN – Value array
  62. Combine query in WP_User_Query()
  63. Multiple nested meta queries
  64. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  65. Custom meta_query order for Elementor based on post meta key [closed]
  66. What’s wrong with this meta query? (order by meta key, then title, doesn’t work)
  67. How can I modify the query by adding to the existing query?
  68. ElasticPress is (aparently) messing with my search filters
  69. Meta query ignores multiple values of the key
  70. Multiple meta_query not returning rows
  71. WordPress Query custom ordering by temporary variable
  72. Check for not NULL not working in meta query
  73. Comparing Meta Field date in WPQuery using Meta_Query?
  74. Get unique post by meta value using wp_query
  75. How to create better WP_Query to look for date time which is anywhere between two meta values?
  76. Query against multiple locations within single custom post type post
  77. WP_Query, ACF field and array
  78. Order by Date Custom Field
  79. Filtering WP_Query based on wp_postmeta keys values
  80. WP Query. Ordering posts by another post types meta
  81. Multiple meta_query not working
  82. compare for multiple meta values for same key in wp_query
  83. datetime picker, timestamps and meta queries
  84. WP_Query with meta_query won’t orderby
  85. meta_query only check if both value are set
  86. Get posts meta_query by repater field
  87. Query 3 meta_key and orderby
  88. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  89. meta_query not working with the_content()
  90. Using custom field as ‘orderby’ value causing post grouping by publish date
  91. Get closest event where meta_key field is an array
  92. Meta_query weird behaviour
  93. Looking for a way to exclude frontpage and nav menu from query filter
  94. Creating Custom Query
  95. Get posts by meta value except one post [closed]
  96. WP_Query by meta key not returning any posts
  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

Leave a Comment