Add filter post_where and passing post_type argument

Remove this part from your posts_where filter:

if (is_search() && get_search_query())

Note that is_search() is a check on the main query.

If you want to target the main search query, there’s the posts_search filter available.

Important: Watch out for possible SQL injections, as you are taking user input into the SQL query. I think the FILTER_SANITIZE_STRING filter is too weak here, as it allows e.g. parentheses, where it allows the user to modify the structure of the SQL query. Consider $wpdb->prepare() with %for %F type specifiers for floating point numbers.

Related Posts:

  1. Post_count only shows the number of results per page
  2. WP Query where title begins with a specific letter
  3. Search custom taxonomy term by name
  4. Order Search Results Page by meta_value If no Value Return Remaining Results
  5. Tracing the life of a query
  6. Pagination not working for Custom search form & custom result template
  7. Pagination broken when merging search results with additional WP_Query
  8. How to search by title or tags exclusively?
  9. WordPress search exact match
  10. Pagination wont work with search results template [duplicate]
  11. How do I search WordPress by different fields without a plugin?
  12. Multiple keyword search
  13. Using next/previous_posts_link with customised search
  14. WordPress custom search form with pre_get_posts not work
  15. Add custom search results to main WP search [duplicate]
  16. WP Query search for attachments and their exact title
  17. Modifying the Search Results
  18. How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
  19. Complex date range with WP_Query and BETWEEN
  20. Creating a custom search for a specific post type
  21. Custom Search Result Page displaying only 1 result.
  22. showing all search result in one template
  23. Querying on multiple taxonomies pulled from $_GET checkbox array not working?
  24. WordPress pagination not working with search page
  25. Is there any advantage of using default WordPress Search instead of creating a custom one?
  26. WP_Query Not Recognizing Taxonomy Parameter in Custom Search
  27. Search pages that are a child of the current page
  28. Include tags in WP_Query
  29. Search for multiple tags?
  30. Custom Search Not Consistent with Results
  31. Editing the default wordpress search
  32. How to use wp_query to post count by search term > group post count by date > convert to json. (ex. result 12-21-2020 – 343)
  33. Multiple Search Terms WP_Query
  34. Extend product search with meta in WooCommerce
  35. WP Query Args – Title or Taxonomy Value
  36. Query with search and subscribers only output
  37. Search by post id in a specific page then auto-redirect to searched post
  38. Search for “2nd” also returns “22nd” in wp_query
  39. Categorising search results based on Custom Fields
  40. using pre_get_posts for search results not found
  41. wp_query search not taking keywords with together for multiple words
  42. Wildcard search in WP Query
  43. Get a list of posts by specific category
  44. Search Page Returns Nothing
  45. Redirect Search to Form When No Product Results Are Found
  46. How to avoid bypass of search bar rules?
  47. Hide products in uncategorized category from search results
  48. Issues with search after added meta_query
  49. How do you determine if a result in a search query is a post or a page?
  50. Sorting search results with custom dropdown
  51. wp_query show all values
  52. change posts_orderby of the callback wp_query?
  53. How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
  54. Searching post types
  55. Ignore image urls in wp_query search
  56. Search.php – return number of results but cannot loop through
  57. How to filter a static post page with ajax and $wp_query
  58. Searching not only by post name but also category
  59. $wp_query->found_posts not returning correct value
  60. How to search by slug and old slug in single API
  61. WordPress search WP_Query to cover multiple post types and their custom fields?
  62. How to prevent WP_Query from filtering on ‘s’ but keep ‘s’ for other purposes?
  63. Block internal search queries with pre_get_posts and regex rules
  64. Add dynamic search to paginated WP_Query
  65. Search Exact on WordPress – Relevannsi Solution Not Working
  66. How to sort store location by specific category order in WP store locations
  67. Pagination repeating posts on search results
  68. WordPress Query for CPT that only shows posts within radius of current user’s geolocation
  69. Multiple WP_Query args combinations according to post type
  70. Categories In English version showing not canonical URL, instead shows query search result
  71. Filter admin ajax data by url query
  72. Display the search results like the original pages
  73. How to use jQuery validation to set the search bar to accept only a specific input?
  74. How to debug none working search query?
  75. Search with WP_Query, but ignore href URLs in anchor tags?
  76. WordPress search page pagination displaying but not functional
  77. Limit default Search query to post_title
  78. Search Field that allows options of “Match any keyword” or “Match all keywords”
  79. Order & Orderby clause not working with custom query
  80. How can I modify standard search query to include also ACF custom fields values?
  81. How to make the default WordPress search return borader results
  82. WordPress WP_Query offset parameter not working with search parameter
  83. WordPress WP_Query Array Custom search via taxonomies
  84. Need help setting up a search form for wordpress [duplicate]
  85. Search Query that Includes Custom Table
  86. Manipulating a query
  87. Custom search: Search posts but display parent page in results
  88. Query posts by custom fields
  89. Searching in specific custom post type
  90. Search (Custom Form, Custom Search Result)
  91. Help with showing text when something is entered in my search bar
  92. Filtering product search results using tags
  93. WordPress WP_Query Search (‘s’) With Multiple Search Terms
  94. Search query alteration not working for meta values
  95. Search results stuck on page 1
  96. Custom Taxonomy in custom REST API search
  97. Advanced Search – Is this possible?
  98. How to include custom fields in wordpress search
  99. Extend search query to search meta keys values based on search string
  100. AJAX multiple search boxes not merging with array merge