pre_get_posts or $where, which one to use?

In general this would make sense at pre_get_posts since you could just express conditions as meta query and let WP figure out SQL.

In your specific case this won’t work, since that format is horrible for programmatic comparison. Unless you can change format to something more friendly, you will probably have to write some pretty custom SQL to make it work.

Related Posts:

  1. When querying a combination of posts and other meta fields, is there a better solution than directly modifying the WHERE value?
  2. Should I use Pre Get Posts or WP_Query
  3. Using pre_get_posts with WP_Query
  4. Return only Count from a wp_query request?
  5. What is “main query”? [duplicate]
  6. Prevent pre_get_posts filter on specific post type
  7. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  8. How to uniquely identify queries?
  9. pre_get_posts with get_posts
  10. Is it true $wpdb->get_results is faster than WP_Query in most cases?
  11. Changing Posts Per Page and offset with pre_get_posts
  12. “pre_get_posts” firing on every query
  13. Use WP_Query with a custom SQL query
  14. Using is_main_query to select custom post type on certain page
  15. Multiple orderby parameters in pre_get_posts() action
  16. How to make an activities stream mixing posts and comments?
  17. SQL Statement generated by WP_Query not producing expected results
  18. How do I create my own nested meta_query using posts_where / posts_join?
  19. How to use filter hook posts_join for querying taxonomy terms in posts_where?
  20. How to pass custom parameter to WP_Query for filtering in pre_get_posts
  21. Query with pre_get_posts to get pagination
  22. Single page theme that uses pages for the content
  23. WordPress custom search form with pre_get_posts not work
  24. order by multiple meta keys in pre_get_posts
  25. Should close $wpdb via $wpdb->close()
  26. WP_Tax_Query with post_tag not working
  27. Using pre_get_posts on a specific core/query block
  28. Get the Plugin Which Triggered a MySql Query in WordPress?
  29. How to change posts order on Category and Tag archives?
  30. Mysql query LIKE not working
  31. Formulate a url to show posts with both taxonomy terms
  32. Offset Page Loops and Pagination
  33. How to correctly pass values to wpdb->prepare()?
  34. pre_get_posts order by not working
  35. Adding a parameter to the default query
  36. Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
  37. What’s the purpose / logic of split_the_query in WP_Query->get_posts
  38. How to change main query based on post meta
  39. new WP_Query to get max price meta value not working
  40. Display posts from only one post form in custom query and exclude in main query
  41. WP_Query, pre_get_posts and offset
  42. Complex WP SQL Query
  43. Custom Query num_rows returns wrong amount
  44. Getting post revision and printing them on the post content site
  45. Filtering posts from different categories into different section by doing WP_Query only once
  46. Iterating through $wpdb query without using get_results for large query results
  47. wp_Qwery works to slow
  48. Filtering out child category posts from parent category archive not working
  49. Wp query show post by author name or post title or post content
  50. How to query custom post types with mixed AND & OR statements for custom fields
  51. Query most popular terms by taxonomy over 2 week period
  52. Shouldn’t I be able to modify the main query by this filter?
  53. Custom query: Get all posts that are from a certain category?
  54. using pre_get_posts for search results not found
  55. Ajax future single post query doesn’t work when NOT logged in
  56. Woocommerce – exclude only older out-of-stock items
  57. WP Query – order posts by meta field first and then order the rest
  58. Make a SQL query with wpdb in WordPress
  59. List of ways to access WordPress database?
  60. Specify strict ‘order by’ in WordPress query
  61. How I can change the condition or compare operator for WP_Query in pre_get_posts
  62. Does WordPress have something like Drupal’s DB API?
  63. WP_Query – How to get all posts of specific days of week by custom field date?
  64. Use have_posts() with array of post results retrieved by $wpdb->get_results
  65. how to translate countries output from wp database?
  66. What’s wrong with this wpdb query?
  67. tax_query in pre_get_posts
  68. $wp_query->found_posts not returning correct value
  69. Elementor posts custom query based on tag [closed]
  70. Exclude post with taxonomy and from the terms (taxonomy & tag) posts count
  71. `offset` WP_Query argument dont work via `pre_get_posts`
  72. Replace wp_query with wp_user_query
  73. Make a products only viewable to a specific user ID in meta_query pre_get_posts
  74. pre_get_posts pagination not working
  75. Save queried result into database
  76. meta_query is overriding default search
  77. Any way to use FETCH_KEY_PAIR with $wpdb?
  78. order posts by a secondary query that counts items
  79. How to get user avatar via WPDB
  80. Woocomerce – Order products by float attribute in archive pages
  81. Order posts by title and custom field value?
  82. Limit default Search query to post_title
  83. why doesn’t this pre_get_posts code work?
  84. pre_get_posts with WP_Query to prevent posts from specific tags
  85. What argument does my function need to echo get_results() query results
  86. Using the same WP_Query for shop and widgets in WooCommerce shop
  87. complex query question
  88. Adding a Theme Customizer Control for Posts_Per_Page
  89. Order posts by custom column using pre_get_posts
  90. Fire query on ajax post url page
  91. Search Query that Includes Custom Table
  92. Looking for a way to exclude frontpage and nav menu from query filter
  93. pre_get_posts redirecting
  94. Custom post types loop on a page template
  95. Different sql queries count indicator on the main page [closed]
  96. wpdb LIKE request shows all database data
  97. Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
  98. how to use transient method?
  99. get_post_meta bringing back results, but $wpdb->postmeta doesn’t
  100. Is there another way to retrieve a post_id from post_meta other than a SQL query?