i currently have the following search query
PHP Code:
$get_search = "SELECT *, MATCH(comp_name, comp_desc) AGAINST ('$search_var' IN BOOLEAN MODE) AS relevance FROM $table WHERE MATCH(comp_name, comp_desc) AGAINST('$search_var' IN BOOLEAN MODE) ORDER BY relevance DESC";
say I search for candy... and I have an entry call Candy Land and Walmart... in Walmart's description candy comes up a few times... so the results shows walmart first then candy land... is there a way to set priority on the name then the desc? |
