Re: Name searches for the spelling impaired

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, 6 Sep 2004 11:09, Pete Holsberg wrote:

> Is there a way to program MySQL so that it can find the
> name "Smyth" if the user looks for "Smith"? And similar
> mispellings that are similar in sound.

The SOUNDEX string function in mysql may be what you want.

http://dev.mysql.com/doc/mysql/en/String_functions.html

Something like

SELECT fields FROM table WHERE SOUNDEX(name) = SOUNDEX('searchvalue')

Cheers
-- 
David Robley

Lead me not into temptation, I can find it myself.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux