Wildcard search in WP Query

WP_Query will add the % wildcard operators for a LIKE query. Just remove those. As is your query looks like LIKE '%\\%rocket\\%% which is not what you want. Try

var_dump($query->request);

And you can see that for yourself.

Related Posts:

  1. Can I force WP_Query to return no results?
  2. Post_count only shows the number of results per page
  3. WP Query where title begins with a specific letter
  4. Search custom taxonomy term by name
  5. Order Search Results Page by meta_value If no Value Return Remaining Results
  6. Tracing the life of a query
  7. Want to redirect if search query match exact title of any post
  8. Pagination not working for Custom search form & custom result template
  9. How to support multiple search terms query within one process?
  10. Pagination broken when merging search results with additional WP_Query
  11. Custom search form with empty parameters
  12. How to search by title or tags exclusively?
  13. WordPress search exact match
  14. Pagination wont work with search results template [duplicate]
  15. How do I search WordPress by different fields without a plugin?
  16. Multiple keyword search
  17. Using next/previous_posts_link with customised search
  18. WordPress custom search form with pre_get_posts not work
  19. Search – Ajax – Alter Query Parameters with Pagination
  20. Add custom search results to main WP search [duplicate]
  21. Multiple search queries on one page
  22. tax_query shows no results if nothing is selected
  23. Searching through different categories on different pages code is not working
  24. WP Query search for attachments and their exact title
  25. WP_Query’s “request” SQL Query
  26. Including only current user’s posts in search
  27. is_search was called incorrectly
  28. How do I search inside specific taxonomies in WordPress
  29. Modifying the Search Results
  30. Custom category search box for WordPress
  31. Refine search results using WP_Query
  32. How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
  33. Search Posts with Custom Fields as query
  34. Complex date range with WP_Query and BETWEEN
  35. Creating a custom search for a specific post type
  36. Custom Search Result Page displaying only 1 result.
  37. How to loop for every result found in the_content() when using the search query?
  38. Assigning a meta_query value based on regexp to wp_query fails
  39. showing all search result in one template
  40. Querying on multiple taxonomies pulled from $_GET checkbox array not working?
  41. Is there any advantage of using default WordPress Search instead of creating a custom one?
  42. WP_Query Not Recognizing Taxonomy Parameter in Custom Search
  43. Search pages that are a child of the current page
  44. Include tags in WP_Query
  45. Search for multiple tags?
  46. Custom Search Not Consistent with Results
  47. wp_query ‘s’, search filter with pagination is not working
  48. Editing the default wordpress search
  49. 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)
  50. Multiple Search Terms WP_Query
  51. Extend product search with meta in WooCommerce
  52. WP Query Args – Title or Taxonomy Value
  53. Display Search Results by tag_ID in my search.php
  54. How to debug none working search query?
  55. getting posts by tags
  56. Add to search posts query array with post IDS which will appear first
  57. Custom Post Type WP_Query with filters and search
  58. Search with WP_Query, but ignore href URLs in anchor tags?
  59. WordPress search page pagination displaying but not functional
  60. Search has query that will return no results
  61. WP Query – Search in title or author_name
  62. Limit default Search query to post_title
  63. Get posts by similar names and categories
  64. Logging search queries for logged-in users
  65. How to show terms from another taxonomy
  66. Search Field that allows options of “Match any keyword” or “Match all keywords”
  67. Order & Orderby clause not working with custom query
  68. How can I modify standard search query to include also ACF custom fields values?
  69. A very strange problem with search query
  70. Search format not matching taxonomy query
  71. How to make the default WordPress search return borader results
  72. Search Functionality broken by the wp 4.2 update
  73. WordPress WP_Query offset parameter not working with search parameter
  74. Custom search (wp query by custom fields)
  75. WordPress WP_Query Array Custom search via taxonomies
  76. Custom Search Query – include only custom fields and title
  77. $wp_query when new WP_Query
  78. Need help setting up a search form for wordpress [duplicate]
  79. Search Query that Includes Custom Table
  80. Manipulating a query
  81. Custom search: Search posts but display parent page in results
  82. Query posts by custom fields
  83. Searching in specific custom post type
  84. Search (Custom Form, Custom Search Result)
  85. Help with showing text when something is entered in my search bar
  86. Why does WP_Query not search for two ‘meta_query’ keys separated with OR?
  87. Filtering product search results using tags
  88. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  89. WordPress WP_Query Search (‘s’) With Multiple Search Terms
  90. How does Show Posts based on a keyword search work in WP_Query
  91. Search query alteration not working for meta values
  92. Search results stuck on page 1
  93. Custom Taxonomy in custom REST API search
  94. Advanced Search – Is this possible?
  95. How to include custom fields in wordpress search
  96. Extend search query to search meta keys values based on search string
  97. AJAX multiple search boxes not merging with array merge
  98. Removing filename searches when searching attachments
  99. Modify WordPress Search
  100. Rewrite URL custom search query
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)