[Plugin: Dave's WordPress Live Search] It should have option to search within post titles

Hello
I would like to know if you have manage to search only in post title for live search ?

Thanks

@jchbox Hello, sadly friend I am still unable to figure out how to do so and waiting for reply from the developer. Did you find any success in search within the post titles?

Thanks

Hi guys,

Searching within post titles is outside the scope of this plug-in. This plug-in really is only meant as a front end to the built-in WordPress search. If you would like to add such functionality to your site, please check out the Search Everything plug in.

Thanks
Dave

@jchbox Hi, I’ve found a solution to search within titles, here’s the code you need to enter into your theme’s functions.php file.

<?php
/**
 * Search SQL filter for matching against post 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( like_escape( $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 );
?>

And let the Dave’s wonderful live search plugin turn on and see the results.

I will check this tomorrow
I have allready see this code on a forum
i was wondering if this will restrict all search form to title field

Thanks