Re: Looking for info on Fuzzy Searching with MySQL

2001-05-15 Thread hooker
> > I found FULLTEXT (MATCH/AGAINST) indexes and the SOUNDEX function. Are > there other MySQL features that help with Fuzzy searching? > > Soundex seems very useful, but I'm not sure how to apply it to multi-word > strings. > > I'd also be interested in pointers to general info on writing f

Re: Looking for info on Fuzzy Searching with MySQL

2001-05-14 Thread Chris Nichols
Here's the approach I used for searching through a table that needed to search 7 different fields in the table and weight them differently: I run through this expression for each word that's split from the searchstring and through each field with different weights given to each field. Then th

Looking for info on Fuzzy Searching with MySQL

2001-05-14 Thread Bill Marrs
I found FULLTEXT (MATCH/AGAINST) indexes and the SOUNDEX function. Are there other MySQL features that help with Fuzzy searching? Soundex seems very useful, but I'm not sure how to apply it to multi-word strings. I'd also be interested in pointers to general info on writing fuzzy searches. A