Re: Daitch-Mokotoff Soundex

[Andrew Gilfrin]

You can use the soundex function.

SELECT SOUNDEX('Hello');

SELECT * from EMPS where SOUNDEX('SMITH') = SOUNDEX('SMEETH');

or you can use the sounds like command

SELECT * FROM EMPS WHERE surname sounds like 'smith';

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information