MYSQL Search

[BigBadDave]

I have made a search using LIKE syntax but my problem is if my field has more than one word in it, I can't match against the other words in the field only if the search string exactlly matches the word set

How do I overcome this?? Regards

Big Bad Dave

davidbyng@hotmail.com

 

[piti]

try fulltext indexing and search, the search is then based on similarity

details here:

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Fulltext_Search

 

[BigBadDave]

I have managed to do it by spliting the field up using preg_split() and looping through matches etc Regards

Big Bad Dave

davidbyng@hotmail.com

 

[AnakinPt]

try this:

$words=explode(" ",$search);

while(list($index,$value)=each($words)){
if (strlen($value)>2){
$words[$index]="text like '%$value%'";
}
}
reset($words);
$query="SELECT ... WHERE text like '%$search%' or ".implode(" or ",$words)." ORDER BY ... ";
Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com