Meta query with string starting like pattern

You could try the REGEXP version:

    'meta_query' => array(
        array(
            'key'       => 'email_address',
            'value'     => '^hello@',
            'compare'   => 'REGEXP',
        )
    )

where ^ matches the beginning of a string.

You can check the MYSQL reference on REGEXP here for more info.

Notice that these are the possible values of the meta compare parameter:

'=', '!=', '>', '>=', '<', '<=', 
'LIKE', 'NOT LIKE','IN', 'NOT IN', 
'BETWEEN', 'NOT BETWEEN', 'NOT EXISTS', 
'REGEXP', 'NOT REGEXP', 'RLIKE'

according to the WordPress 3.9.2 source.

From the MYSQL ref:

Name        Description
------------------------------------------------------
NOT REGEXP  Negation of REGEXP
REGEXP      Pattern matching using regular expressions
RLIKE       Synonym for REGEXP

Related Posts:

  1. compare meta_query in get_posts arguments
  2. Getting attachments by meta value
  3. querying with custom meta field with meta_query
  4. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  5. WordPress altering my custom query, How to fix it?
  6. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  7. Order by meta_key in custom post type doesn’t affect the query
  8. meta_key and meta_value not working together
  9. Order Posts by meta value AND published date
  10. How to make Meta Query case sensitive?
  11. Fetch Record based on meta key dates
  12. Meta_query with multiple keys and multiple values
  13. meta_query BETWEEN, but the range is stored in the custom field
  14. Extend product search with meta in WooCommerce
  15. how to make members list directory through wordpress post custom meta key.
  16. Large AND OR query timing out
  17. meta_value_num not ordering all items
  18. meta_compare not comparing whole integer
  19. Display posts with specific value first in query
  20. Get every post with value in meta key
  21. add_query_arg to compare and display events from a certain date
  22. Comparing 2 Decimal Numbers from custom fields and displaying posts
  23. meta_query weird behaviour, static int will work, but not user data
  24. Query multiple post types, but different order for each
  25. Order by the first array within a meta_query
  26. Query ACF relationship field – Comparator IN – Value array
  27. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  28. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  29. How do i create a custom post query when the meta value is an array?
  30. WP Query – grouping posts by same meta key, adding together values from another key
  31. meta_query is overriding default search
  32. Trouble with serialized metadata
  33. Comparing Meta Field date in WPQuery using Meta_Query?
  34. Getting posts by custom field value
  35. Query against multiple locations within single custom post type post
  36. WP_Query, ACF field and array
  37. Order by Date Custom Field
  38. Query by meta value (add a dropdown of all values)
  39. Order Posts By Custom Field That is an array of objects
  40. Custom WP_query and integrating into theme file
  41. Using custom field as ‘orderby’ value causing post grouping by publish date
  42. Compare meta key separation
  43. query post based on comparison
  44. Get posts by meta value except one post [closed]
  45. WP Query Args – Title or Meta Value
  46. how to show posts that are missing a meta_value
  47. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  48. Get_post() with meta_key when compare is a date
  49. Order by two meta keys
  50. multiple meta key but get server load is very high
  51. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  52. How can I combine meta_query queries?
  53. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  54. Use meta_query to display events by date in custom field
  55. wp_query with multiple custom fields
  56. How to show recent and upcoming birthdays using meta_query
  57. Using WP_Query and WP_Meta_Query Outside of WordPress
  58. If two first numbers exist in wp_meta_query value
  59. WP_Query on custom field and order results
  60. Tax query clause inside a meta query clause?
  61. Display custom field meta outside loop, site wide
  62. Optional Meta Query
  63. How do I make a meta_query OR relation work? [closed]
  64. Meta_query on same meta key, with diffrenct values
  65. Can we return all category (not post) with Custom Query Filter? [closed]
  66. WP_Query with meta_query dosen’t return results
  67. How to provide meta_key array to wp_query?
  68. Order post type by sum of two custom fields
  69. Meta query compare for ID’s greater than specific ID
  70. Is it possible to add relation between meta_query and tax_query?
  71. Order WP_Query results by meta key value in custom query
  72. Show single posts date, in a page of posts
  73. WP_Query Class custom field parameters
  74. meta_query where the meta value is not the post title
  75. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  76. How to add a “base” filter for all posts visible to visitors on the site?
  77. meta_query with meta values as serialize arrays
  78. Woocommerce Get Orders By Meta Value
  79. Multiple WP_Query args combinations according to post type
  80. WP_Query multiple value not working
  81. WP_User_Query Orderby Not Working
  82. Unusual high query of user meta data
  83. WordPress Query optimaization for slow query
  84. Meta query doesn’t remove placeholder escape before query
  85. How to create URL parameters to run custom queries?
  86. WP Query Meta Query
  87. Query custom meta value – post view and date meta
  88. How can I modify standard search query to include also ACF custom fields values?
  89. WP_Query – show posts where meta value and user_email match
  90. Best way to Order Post in Home without a plugin
  91. WP_Query using meta_query with LIKE doesn’t return what it should
  92. Loop through multiple custom fields with increasing number
  93. Return a single custom post from multiple meta queries
  94. new WP_query using custom fields
  95. Including ‘cat’ => $cat breaks meta_query
  96. Query string form $_GET[‘value’] is not working as meta value in wp_query
  97. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  98. Get posts using multiple values from ACF checkbox as meta query wordpress
  99. WP Query returning all posts when Meta_query is null
  100. Order custom post type by posts with most likes first

Leave a Comment