searching (Re: [Webdev] writing SQL neatly.)

[John P. Looney (Kate)]

On Wed, Jun 14, 2000 at 09:27:22AM +0100, Donncha O Caoimh mentioned:
> adam beecher wrote:
> > 
> > Ok, Donncha - there's your first topic for the BOF, you can train me up too:
> > 
> > "Searching a MySQL database."
> 
> Just found the following posted to the MySQL mailing list this morning.
> Presumably it carries over to other databases too..
> -------------------------------------
> Subject: Re: fuzzy searching with MySQL
> [snip]
> 
> This is actually language independent:
> 
> select word from dict where SOUNDEX('testword') = SOUNDEX(word);

 They have that in most databases. It's a bit mad...

Kate

-- 
"The fool must be beaten with a stick, for an intelligent person 
the merest hint is sufficient"                -- Zen Master Greg