> I'd like users to be able to enter the first > few characters of a contact's name to do a search, and I'd > like the option of doing inexact matches or phonetic matches.
MySQL does have the SOUNDEX function; see the docs for details...
SELECT * FROM people WHERE SOUNDEX(lastname) = SOUNDEX('Smith');
I'm sure others can suggest optimizations...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
