Query posts if meta key starts with

I figured it out:

$the_query = new WP_Query(array(
    "numberposts" => -1,
    "post_type" => "plays_events",
    "meta_query" => array(
        array(
            "key"     => "show_times_%_date",
            "value"   => $this_month . "[0-9]{2}",
            "compare" => "REGEXP"
        )
    ),
));

Related Posts:

  1. Query reset problem or flawed code to enable custom post type query
  2. How to fix pagination for custom loops?
  3. AJAX with loop filtering categories
  4. Remove the Homepage Query
  5. Is `query_posts` really slower than secondary query?
  6. Are there any scenarios where the query_posts may be used?
  7. Transient not working for custom loops
  8. loop query exclude meta_key with meta_value
  9. post loop causes wp_users and wp_usermeta DB queries for each users
  10. Sort Popular Posts by Views for the Last Week
  11. get_the_foo() in the loop – does it perform another query?
  12. If No Search Results, Show Posts from Alternate Search Query
  13. Exclude filter on front page
  14. How to Loop within a Loop (Display Children and then Grandchildren)
  15. Loop posts only excluding first post
  16. Filtering The Loop For Single Page and Blog Page
  17. Sort Posts By Category?
  18. Custom search form to display users only
  19. Loop after page content
  20. How to get an array of years from all of the search results, and use it to filter by year the paginated loop?
  21. Meta Query with spaces in value?
  22. A loop with all articles with certain text strings in tags
  23. Display most viewed post from last 30 days is not working correctly
  24. 3 Posts in Loop, Show Stickies First
  25. How to return only one instance of each, from the entire loop
  26. How to go about combining dropdowns / filter queries?
  27. Query last updated posts (posts updated in the last 24 hours)
  28. Combining action and filter?
  29. Filter the loop by categories using checkbox form
  30. Conditional query that displays on Woo product attribute pages
  31. How do I use AJAX Query in my posts loop?
  32. woocommerce get_price_html not pulling in correct price
  33. Exclude posts from main loop based on meta value
  34. Filter the_posts doesn’t work on search page
  35. How to fix pagination for custom loops?
  36. Sanitize Custom Field Value in Meta Query
  37. How can I paginate this?
  38. How to display posts by vote count and if no value continue with latest posts with no votes?
  39. How to fix pagination for custom loops?
  40. Split wordpress loop to multiple layouts
  41. Making a query to the DB using same parameters of loop
  42. Custom loop not working
  43. Loop inside query
  44. Trying to get property of non-object in shortocde
  45. Randomly display post based on meta value. (Kind of Priority/Weight)
  46. Make a loop to return x number of posts, but only if they have content or excerpt
  47. get_delete_post_link() inside Loop stubbornly returns nothing
  48. loop inside the foreach
  49. Query posts only with actual text content (not including shortcode or images)
  50. Filter existing hook using parameter and foreach loop
  51. Exclude posts based on an array
  52. Query post & loop problem.
  53. Excluding posts by meta, and also keeping posts without the meta
  54. Get current taxonomy and display query accordingly
  55. Loops for cat links not looping for wordpress site
  56. How do I set the Stewart Search Template to return only published posts in the result
  57. Loop order issue with Ajax filter
  58. Trying to get all links in my posts
  59. Query users and count totals based on meta values
  60. Custom Query with Sticky Posts
  61. Add Search and Filter functionality to custom loop
  62. Build a Page which shows the Oldest Post with specific Custom Field Value
  63. Exclude Posts Using Meta Query and User Meta
  64. Reorder posts in a loop: have the posts by one particular author below the others
  65. Query posts and display all dates in repeater field in chronological order
  66. How to filter get previous post function by meta value DESC and post date DESC?
  67. WordPress redundant posts based on meta field
  68. How to fix pagination for custom loops?
  69. Get featured image outside the loop using foreach
  70. Attachment Metadata inside of Loop
  71. Alternative layout the loop
  72. Show posts by tags excluding current post
  73. Remove posts_orderby filter then add it back in
  74. Strange problem with wp_get_attachment_image_src database (db) query count
  75. Advanced Post Display/Pagination/Ordering
  76. Next 10 posts data of currently viewing post in blog page
  77. How to fix pagination for custom loops?
  78. Buddypress Group Activity Loop Filter activity type [closed]
  79. get_posts and wp_autop (remove filter)
  80. How to fix pagination for custom loops?
  81. How to fix pagination for custom loops?
  82. Get query result before posts are displayed?
  83. Combine Query and Select Database to create directory loop
  84. WordPress loop: Display if posts exist
  85. wordpress showing all posts instead of date range
  86. Help with add_filter(‘the_content’, ‘some_function’) and multiple matches
  87. Applying a filter to multiple loops for days ago
  88. Multiple loop with pagination in same page
  89. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  90. Query Loop Block: possible to restrict just child pages?
  91. Use Base-URL with Query-Loop
  92. Display date only once for a each set of posts relating to that date
  93. Combining the_excerpt with the_content
  94. Escape current post from loop
  95. Rendering pages
  96. How can have a conditional template tag based on the main loop within a secondary loop with new WP_Query(), using get_template_part()
  97. How to filter posts by category INSIDE the loop
  98. Adding a second loop breaks everything
  99. Return only one post format in index.php [duplicate]
  100. Return only content in excerpt field in loop