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. Search custom taxonomy term by name
  3. Want to redirect if search query match exact title of any post
  4. Pagination not working for Custom search form & custom result template
  5. How to support multiple search terms query within one process?
  6. How to search by title or tags exclusively?
  7. WordPress search exact match
  8. Pagination wont work with search results template [duplicate]
  9. How do I search WordPress by different fields without a plugin?
  10. Using next/previous_posts_link with customised search
  11. WordPress custom search form with pre_get_posts not work
  12. Search – Ajax – Alter Query Parameters with Pagination
  13. Add custom search results to main WP search [duplicate]
  14. tax_query shows no results if nothing is selected
  15. Searching through different categories on different pages code is not working
  16. WP_Query’s “request” SQL Query
  17. Including only current user’s posts in search
  18. is_search was called incorrectly
  19. How do I search inside specific taxonomies in WordPress
  20. Modifying the Search Results
  21. Refine search results using WP_Query
  22. Search Posts with Custom Fields as query
  23. Complex date range with WP_Query and BETWEEN
  24. How to loop for every result found in the_content() when using the search query?
  25. showing all search result in one template
  26. Querying on multiple taxonomies pulled from $_GET checkbox array not working?
  27. WP_Query Not Recognizing Taxonomy Parameter in Custom Search
  28. Custom Search Not Consistent with Results
  29. wp_query ‘s’, search filter with pagination is not working
  30. Editing the default wordpress search
  31. Multiple Search Terms WP_Query
  32. WP Query Args – Title or Taxonomy Value
  33. WordPress pagination not working on template search.php
  34. wordpress search word, “hello world” ===> ‘hello+world’ ===> ‘hello’, ‘world’
  35. Search Query for multiple categories using ‘OR’ but having certain categories be ‘AND’
  36. query_vars overriding WP_Query args
  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. How to make search for posts using get method?
  40. Categorising search results based on Custom Fields
  41. Add filter post_where and passing post_type argument
  42. using pre_get_posts for search results not found
  43. Search posts missing a particular custom field
  44. Replacing search results with custom external query
  45. wp_query search not taking keywords with together for multiple words
  46. Get a list of posts by specific category
  47. WordPress Custom Search Form Displaying Unexpected Results
  48. Search Page Returns Nothing
  49. Redirect Search to Form When No Product Results Are Found
  50. Issues with search after added meta_query
  51. Slow Query On Search
  52. Sorting search results with custom dropdown
  53. How To Keep Search Title the same on paged Results
  54. change posts_orderby of the callback wp_query?
  55. How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
  56. Search.php – return number of results but cannot loop through
  57. Can I make a search query which includes a space?
  58. How to filter a static post page with ajax and $wp_query
  59. Searching not only by post name but also category
  60. $wp_query->found_posts not returning correct value
  61. How to search by slug and old slug in single API
  62. Block internal search queries with pre_get_posts and regex rules
  63. How to make the WP query search for the “s” arg in other places too
  64. Search Exact on WordPress – Relevannsi Solution Not Working
  65. Excluding posts from search results page with meta query not working
  66. Pagination repeating posts on search results
  67. I have problems with the search query using multiple post types
  68. WP_Query no result if keyword contains number
  69. Categories In English version showing not canonical URL, instead shows query search result
  70. Filter admin ajax data by url query
  71. How to extend WP_query to a specific table?
  72. Display Search Results by tag_ID in my search.php
  73. How to debug none working search query?
  74. getting posts by tags
  75. Add to search posts query array with post IDS which will appear first
  76. Custom Post Type WP_Query with filters and search
  77. Search with WP_Query, but ignore href URLs in anchor tags?
  78. Get posts by similar names and categories
  79. Logging search queries for logged-in users
  80. How to show terms from another taxonomy
  81. Search Field that allows options of “Match any keyword” or “Match all keywords”
  82. A very strange problem with search query
  83. Search format not matching taxonomy query
  84. How to make the default WordPress search return borader results
  85. Search Functionality broken by the wp 4.2 update
  86. Custom search (wp query by custom fields)
  87. WordPress WP_Query Array Custom search via taxonomies
  88. Custom Search Query – include only custom fields and title
  89. $wp_query when new WP_Query
  90. Search Query that Includes Custom Table
  91. Manipulating a query
  92. Query posts by custom fields
  93. Searching in specific custom post type
  94. Search (Custom Form, Custom Search Result)
  95. Why does WP_Query not search for two ‘meta_query’ keys separated with OR?
  96. Using ‘meta_query’ with the ‘pre_get_posts()’ hook disables searching for post titles
  97. How does Show Posts based on a keyword search work in WP_Query
  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