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,
> 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(
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 l
SELECT FROM WHERE LIKE '%'
the % is a wildcard and will match up anything after the chars.
you can also put one infront to match ANYTHING with in it.
---8><
Many thanks for taking time to answer an "easy" qu
SELECT FROM WHERE LIKE '%'
the % is a wildcard and will match up anything after the chars.
you can also put one infront to match ANYTHING with 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 co
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.