SELECT <stuff> FROM <table> WHERE <field> LIKE '<Chars>%'
the % is a wildcard and will match up anything after the chars.
you can also put one infront to match ANYTHING with <chars> in it.
hth
Tim
"Computers are like Air-con, open windows and they stop working!"
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.
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.
--
signature.asc
Description: OpenPGP digital signature