4 messages in com.mysql.lists.mysqlRe: Basket o' questions/ideas on full...
FromSent OnAttachments
Don Philtrodt18 Aug 1999 02:07 
Thimble Smith18 Aug 1999 10:43 
Vivek Khera18 Aug 1999 10:52 
Don Philtrodt18 Aug 1999 12:21 
Subject:Re: Basket o' questions/ideas on full-text-searching
From:Vivek Khera (khe@kciLink.com)
Date:08/18/1999 10:52:31 AM
List:com.mysql.lists.mysql

"TS" == Thimble Smith <ti@desert.net> writes:

On a related note... has anybody used/implemented a do-it-yourself word searcher using SOUNDEX()? Are SOUNDEX searches remotely intuitive or more like "why the heck did THAT show up?!"

TS> I think they're usually pretty far off for most applications. For TS> some things (like looking up an address / name in a list of customers) TS> it can be useful. That's just my experience.

That could possibly be because the soundex algorithm is designed for finding English surnames. It doesn't work very well on other words or names of different ethnicity.

What I'd really love to see is the Nextrieve (http://www.nextrieve.com/) full text search engine with the capability to read the TEXT fields directly from the ISAM file. That would be *way* cool.