On Mon, 6 Sep 2004, David Robley wrote: > 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 Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
