On Saturday, March 05, 2005 15:21, Robert S wrote: > Probably a real n00b question. > > I am writing a simple contact management database with MySQL (version > 3.23.49-8.9, Debian Woody). 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.
For phonetic matches you will want to check out the soundex function. http://dev.mysql.com/doc/mysql/en/string-functions.html > What sort of SELECT/WHERE statement do I need to do these things? > > I've combed the documentation and used Google but haven't found any > such thing. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
