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

[Donncha O Caoimh]

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);
-- 
Sasha Pachev
-------------------------------------

Might try that in IO over the weekend if I get time.

Donncha.