WP_Query with meta_value LIKE ‘something%’

For a left-sided match you can get around the automatic adding of '%'‘s by WP by using regular expression RLIKE:

'meta_value' => '^' . preg_quote( $today ),
'meta_compare' => 'RLIKE'

Similarly for right-sided match:

'meta_value' => preg_quote( $today ) . '$',
'meta_compare' => 'RLIKE'

Related Posts:

  1. How to only display posts whose meta_value field is not empty?
  2. Is it possible to orderby multiple meta_keys when using meta_value_num?
  3. Sorting meta_value as integer doesn’t work
  4. Add a default meta_value to new posts
  5. Ordering by meta_value AND date NOT WORKING with wp_query
  6. How to use Meta Value Compare in WP_Query For Max and Min numbers
  7. Custom WP Query from meta_value stored as serialised array
  8. meta_query works locally but not on live server
  9. Ordering Posts Type A by Custom Fields of related Post Type B
  10. Custom query for sidebar isn’t returning results
  11. Need wp_query to return all children and grandchildren
  12. new WP_Query to get max price meta value not working
  13. Query multiple meta values
  14. Why isn’t my `meta_query` array functioning properly?
  15. How to orderby multiple meta fields if some fields are empty
  16. Meta_query on same meta key, with diffrenct values
  17. How to extract specific post
  18. Meta Query relation “AND” then set array accordingly
  19. Does meta_value (array) work with ‘orderby’?
  20. WP Query Meta Value – How To Identify Specific, Unique Values?
  21. query post by author gender
  22. Show posts of an advanced search form
  23. Meta query with compare by more than 2 fields
  24. Order (by ASC) posts with meta_key so posts without values are last
  25. Save queried result into database
  26. WP_Query multiple value not working
  27. Gather same custom field values in one value in a select tag with wp_query
  28. Order posts by more than one variable (meta_key and publish date AND time)
  29. how to query for meta_value have array
  30. Sorting Posts with meta value not working
  31. Cannot order by in WP_Query
  32. Query to get all the posts of more than 2 meta_value having same meta_key?
  33. Order by meta values
  34. query_posts, oderby meta_value & print “future” posts
  35. Get posts by meta value except one post [closed]
  36. get custom post type by tag
  37. Does tax_query really beats meta_query in all situations?
  38. Using WP_Query To Get Posts Randomly From today
  39. WP_Query meta_query by array key
  40. Trying to list out child pages with WP_Query
  41. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  42. Intentionally exceed max_num_pages on main query without getting 404?
  43. Pass the same object to multiple widgets in a template with one query
  44. Count total number of post in foreach loop
  45. WP_Query not retrieving by random order under parent
  46. Get images only if parent status is publish
  47. How to change posts order on Category and Tag archives?
  48. Using WP_Query and WP_Meta_Query Outside of WordPress
  49. query offset countdown by 2 each day?
  50. Filter posts in category archive page by year using a dropdown
  51. Show post number in widget loop
  52. Extend product search with meta in WooCommerce
  53. Custom Query by Author field and meta
  54. Custom wp_query for related posts with cmb2
  55. Include data from custom table in WP_Query
  56. Query posts by last comments
  57. Better wordpress attachment query than this
  58. How to number the posts (ie #1, #2, #3) in a wp_query?
  59. Does wp track views for posts?
  60. How can I check for a thumbnail in WordPress?
  61. WP_query exclude posts of a format
  62. WP_Query gives me different results depending on the category order
  63. Make a SQL query with wpdb in WordPress
  64. post_type argument not working correctly with WP_Query
  65. Use WP_Query or query_posts() or get_posts() for optimizing a site?
  66. how to get wordpress user id when user register
  67. WP query is calling get_userdata and throws error [closed]
  68. How to set up hierarchical relationships without using plugins / meta query
  69. 2 column recent post query not respecting float right [closed]
  70. Meta query compare for ID’s greater than specific ID
  71. WP_Query->request has a limit
  72. Add parameter to first post only
  73. using nav menu id’s
  74. Ignore image urls in wp_query search
  75. Performance concerns: index.php vs taxonomy-$taxonomy.php
  76. Why does apply_filters behave different inside and outside a loop?
  77. meta_query where the meta value is not the post title
  78. Elementor posts custom query based on tag [closed]
  79. Is WP Query skipping to check next post when an argument is not met?
  80. meta_query is overriding default search
  81. Custom Woocommerce Product Query
  82. How can I write a WP_Query that is this specific?
  83. Pagination inside the blog page not working
  84. How to query most recent post for each author?
  85. Custom Query Pagination not working on static front page
  86. Post Template Query with WP_Query?
  87. Wp Query sort order
  88. Adding additional taxonomies to wordpress taxonomy page
  89. why doesn’t this pre_get_posts code work?
  90. Query Top Set Custom Taxonomy In Given Timeperiod
  91. Custom taxonomy and query multi conditions
  92. Best way to Order Post in Home without a plugin
  93. WP_query issue with no posts
  94. How to get query results for the next page
  95. Multiple loop for “featured” items returns wrong posts
  96. Get WP_Query query after execution?
  97. Query string form $_GET[‘value’] is not working as meta value in wp_query
  98. query_posts problem – need help
  99. 294 Queries on Mainpage of WordPress
  100. Pagination on custom post type not working

Leave a Comment

tech