news <[EMAIL PROTECTED]> wrote on 03/05/2005 04:21:26 PM: > 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. > > 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. > Check out the following comparison options For partial word matches: LIKE, RLIKE, REGEXP (http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html) For phonetic matches: SOUNDEX (http://dev.mysql.com/doc/mysql/en/string-functions.html) Full text searching (for starters): http://dev.mysql.com/doc/mysql/en/fulltext-search.html http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html HTH ;-D Shawn Green Database Administrator Unimin Corporation - Spruce Pine
