How to query search only for post titles?

by

Try this

    $posts = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."posts WHERE post_title LIKE '%" . $_REQUEST['s'] ."%' AND post_status="publish" AND post_type="post"");


$do_not_duplicate = $post->ID; 
foreach($tit as $post) { 
if( $post->ID == $do_not_duplicate ) continue; 
?>

Please let me know if any query.

Hope it will help you!