full-text searching mysql databse

sheitan

hello,

do any1 has an idea on how to integrate compite search solution for mysql text fields. i have it working now with the match and against syntaxys but i need to regonize "some word" as a frase , coz for now i;m spliting the query words.

for now i;m using something like that

// Edit querywords
			$query_trim = trim(preg_replace('/[\-\:\/\"\&\%\#\@\!\)\(\<\>\*\,\?\;\|\=\^\~\`\]\[]/' , ' ' , $querywords));
			$keywords = explode(' ', addslashes(strtolower($query_trim)));
			$regular_expression= "" . implode(",", $keywords) . "";
			$keyWordArray=split(",",$regular_expression);
			$arrSize=sizeof($keyWordArray);
			$Keys='';

		  for($i=0;$i<$arrSize;$i++) {
            $Keys=$Keys.$keyWordArray[$i].' ';
	      }
$Keys=trim($Keys);

and then

$search = "SELECT name,summary,MATCH(name,summary) AGAINST('$Keys') AS rel FROM $stable WHERE MATCH(name,summary) AGAINST('$Keys') ORDER BY $order $way LIMIT $count, $pages";

i need to intergrate the google like "query words" syntax and parse whats in brakets as one word

Yegg

well, not sure if I right understood you, but if you need parse fulltext columns for a phrase, not for ANY word from phrase, then you need to use boolean mode:

select * from stable where match(name,summary) against('+word1 +word2' in boolean mode);

this query will search for prases, in what are BOTH words in one time - "+" mean thah word NEEDED, - not needed.

sheitan

hey mate, the boolean mode is clear to me but my aim is to parse the querywords correctly !

that means to be able to search for:
" "white pants" " ,

also with just "white pants"

or " discounted "white pants" "

the othe problem is when u order by relevance in boolean mode the mysql database do some mistakes !

Yegg

select * from stable where match(name,summary) against('"white pants"' in boolean mode);

this will work for you, It will found exactly phrase: white pants (without quotes), but will not find pants white or "white super pants" - all U need to put in " quotes this phrase, and after put all in ' quotes