Make a WP Query search match exactly the search term

This is actually a tricky question, as by stating exact there are two ways in which one can interprit your question –

  1. Only find posts where the whole title or the whole content match exactly. For example, if you search My post is super you would not have returned a post with the title My post is super awesome.
  2. Fine posts where the exact phrase exists, not just part of a phrase. For example, if you search his house you would not have returned a post with the title I love this house, but you would a post with the title I’m going to his house (rubish examples, but hopefully you get the point).

Luckily you can do either, but method 1 is by far the simpler. Add either of these examples to your functions.php file –

Method 1

add_action('pre_get_posts', 'my_make_search_exact', 10);
function my_make_search_exact($query){

    if(!is_admin() && $query->is_main_query() && $query->is_search) :
        $query->set('exact', true);
    endif;

}

The my_make_search_exact() function will be called everytime a query is made, using the pre_get_posts action hook.

To ensure we don’t mess with the query when we don’t need to, within the function we check that we are NOT viewing the admin area, that we ARE constructing the main query and that we ARE making a search.

Method 2

add_filter('posts_search', 'my_search_is_exact', 20, 2);
function my_search_is_exact($search, $wp_query){

    global $wpdb;

    if(empty($search))
        return $search;

    $q = $wp_query->query_vars;
    $n = !empty($q['exact']) ? '' : '%';

    $search = $searchand = '';

    foreach((array)$q['search_terms'] as $term) :

        $term = esc_sql(like_escape($term));

        $search.= "{$searchand}($wpdb->posts.post_title REGEXP '[[:<:]]{$term}[[:>:]]') OR ($wpdb->posts.post_content REGEXP '[[:<:]]{$term}[[:>:]]')";

        $searchand = ' AND ';

    endforeach;

    if(!empty($search)) :
        $search = " AND ({$search}) ";
        if(!is_user_logged_in())
            $search .= " AND ($wpdb->posts.post_password = '') ";
    endif;

    return $search;

}

Credit to tinyGod for this answer – http://tinygod.pt/make-wordpress-search-exact/

Related Posts:

  1. When should you use WP_Query vs query_posts() vs get_posts()?
  2. order by numeric value for meta value
  3. How to query for most viewed posts and show top 5
  4. WP_Comment_Query pagination, delving into the unknown
  5. What is the most efficient way of querying posts based on visits and date for current day?
  6. Custom WP_Query order by post_meta and (author) user_meta
  7. WP_Query for WooCommerce Products
  8. When should you use wp_reset_postdata vs wp_reset_query?
  9. Perform query with meta_value date
  10. Order posts by tags count?
  11. Add and in the header while looping over custom query in page template
  12. Which custom query am I in and how can I access its properties & methods?
  13. How to speed up wp_query, took more 5s to run against 100k posts
  14. WP_query category__in not working, only pulls from first category
  15. Splitting the main query in multiple loops with query_posts and/or pre_get_posts?
  16. How do you query wordpress posts using a math formula between multiple meta field values?
  17. Get image of latest post from taxonomies/categories
  18. Undefined WP_Query::has_posts()?
  19. Is it possible to dynamically get queried term AND taxonomy?
  20. Meta Query for specific months
  21. Different string for specifed post type on posts listing at homepage
  22. if/else on custom query gives 200 OK when condition not met?
  23. Pull post meta with post_query?
  24. How to access a query twice in different template files?
  25. Minimize database queries to user tables?
  26. Query all published post AND attachment with specific mime type
  27. only delete post within query / for each statement (front end)
  28. Add quicklink to in the Admin posts page where I can query by a meta_key
  29. Get all products which have both product category
  30. unable to retrive parent page information
  31. How to detect if query is runned from widget?
  32. How to display user order by role
  33. WP Query related posts by tags
  34. Order by summing multiple values
  35. Order by empty custom field
  36. Check if loop has any categories?
  37. No results found from a $wpdb->get_results() query when trying to join more than one meta key query
  38. How to get list of posts from permalinks?
  39. Is there a reason why Pages are not publicly_queryable?
  40. Check return value of get_posts
  41. Exclude some authors from query
  42. Query only the posts with a post format of “audio”
  43. pre_get_posts – Trying to get property of non-object warning
  44. WordPress query posts with multiple post_meta data
  45. Get a list of posts by specific category
  46. How to check the array values, what WP_Query has brought to me?
  47. How to add custom meta to ‘pre_get_terms’?
  48. Shortcode for custom query not returning results when attributes are added
  49. Should I reset $wp_query?
  50. Yoast primary category query modification
  51. Update query for wp_posts and wp_postmeta
  52. Get specific ACF key and value from all posts – no access to DB
  53. Include one page/post into query which is already returning posts
  54. I am officially missing something about transient posts
  55. Insert images into wordpress post with a query
  56. Why doesn’t my WP Meta Query return any results?
  57. WP_Query meta compare must include ALL array values
  58. Start Query from 2nd Post without offset
  59. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  60. Display upcoming events in the next 30 days by querying posts with timestamp in custom meta
  61. pre_user_query vs pre_get_posts
  62. Adding nofollow to all the post links in get_posts with pre_get_posts or WP_Query
  63. Meta query orderby meta_value_num sorting by role first
  64. Why pagination is not working with tax_query param?
  65. WP_Query & Duplicate entries
  66. How to query users by post count no less than 10
  67. Add to search posts query array with post IDS which will appear first
  68. WP_Query about meta_key and its array value
  69. Create global array to compare inside a query
  70. How to show terms from another taxonomy
  71. My entry results are not consistently alphabetized
  72. Ignoring ‘a’ when sorting posts
  73. Custom query for tag and custom tag from 2 post type
  74. wpdb get_results() returns only 2 rows
  75. Filter posts/pages by user_role array
  76. WP_Query secondary query failing
  77. Search Functionality broken by the wp 4.2 update
  78. Issue attempting a wp_query_posts with tags
  79. Optimising specific Query with ACF meta objects
  80. How to get several fields from wp_query?
  81. add_query_vars does not work
  82. Pagination not working with WP_Query (creates links but no page)
  83. Query custom post type by date field only working when two posts match the query
  84. Divide WP_Query posts by date & post type
  85. Retrieve posts in custom post type and specific taxonomies
  86. Query Posts by date range with fixed beginning and end
  87. query by meta value then date and not empty meta value
  88. New WordPress WP Query using posts from certain categories
  89. Custom post types loop on a page template
  90. Get the number of rows from $wpdb->get_results not working
  91. Parsing External Table Arguments
  92. Get Child Custom Post Content on Single.php?
  93. difference between methods of query
  94. Query posts by meta value and sort by another meta key
  95. How much does $wpdb->prepare(), then $wpdb->query() VS straight $wpdb->query(), can slow down the load time of whole page
  96. how to use transient method?
  97. Pre_get_post on CPT archive page
  98. Get posts that were most recently tagged
  99. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  100. How to get posts that have certain meta key value and order based on another meta key’s value

Leave a Comment