> 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]