WordPress.org

apply_filters_ref_array( 'posts_search', string $search, WP_Query $this )

Filters the search SQL that is used in the WHERE clause of WP_Query.

Contents

Description
Related
- Used By
User Contributed Notes

Description Description

Parameters Parameters

$search: (string) Search SQL for WHERE clause.
$this: (WP_Query) The current WP_Query object.

Source Source

File: wp-includes/class-wp-query.php

Changelog Changelog

Changelog
Version	Description
3.0.0	Introduced.

Used By Used By

Used By
Used By	Description
wp-includes/class-wp-query.php: WP_Query::get_posts()	Retrieves an array of posts based on query variables.

User Contributed Notes User Contributed Notes

4

Contributed by — 2 years ago

Example function search by title only:

function __search_by_title_only( $search, &amp;$wp_query )
{
    global $wpdb;
    if(empty($search)) {
        return $search; // skip processing - no search term in query
    }
    $q = $wp_query-&gt;query_vars;
    $n = !empty($q['exact']) ? '' : '%';
    $search =
    $searchand = '';
    foreach ((array)$q['search_terms'] as $term) {
        $term = esc_sql($wpdb-&gt;esc_like($term));
        $search .= "{$searchand}($wpdb-&gt;posts.post_title LIKE '{$n}{$term}{$n}')";
        $searchand = ' AND ';
    }
    if (!empty($search)) {
        $search = " AND ({$search}) ";
        if (!is_user_logged_in())
            $search .= " AND ($wpdb-&gt;posts.post_password = '') ";
    }
    return $search;
}
add_filter('posts_search', '__search_by_title_only', 500, 2);

Expand full source code Collapse full source code

You must log in before being able to contribute a note or feedback.