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.
SELECT fields FROM table WHERE SOUNDEX(name) = SOUNDEX('searchvalue')
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