I'm currenly working on fulltext search in which I couldn't do a exact match. For example, if I would like to search for exact match for keyword 'mark', it will match 'market', 'marked', 'marks'.......and 'mark' too.
My sql query looks like below :
Code: Select all
if($search_type=='exact_keywords'){
$search_string = "' \"".$search_string."\" '";
}elseif($search_type=='all_keywords'){
$tmp_array = explode(" ", $search_string);
$search_string = "";
foreach ($tmp_array as $key=>$val){
$search_string .= " +(".$val.")";
}
$search_string = "' ".$search_string." '";
}
$sql = "SELECT page_id, url_scheme, domain, pdf_full_path, pdf_full_text,";
$sql .= " MATCH(pdf_full_text) AGAINST ($search_string IN BOOLEAN MODE) AS relevance ";
$sql .=" FROM tbl_pdf_fulltext ";
$sql .= " WHERE page_id = ".$page_id;
$sql .= " ORDER BY relevance DESC limit 0, 10\n";With Best Regards,
Dibyendra