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.


Description Description


Parameters Parameters

$search

(string) Search SQL for WHERE clause.

$this

(WP_Query) The current WP_Query object.


Top ↑

Source Source

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

View on Trac


Top ↑

Changelog Changelog

Changelog
Version Description
3.0.0 Introduced.


Top ↑

User Contributed Notes User Contributed Notes

  1. Skip to note 1 content
    Contributed by

    Example function search by title only:

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

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