Perhaps this could help you out..
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_soundex
- michael dykman
On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer <mspreitz@stripped> wrote:
> Suppose I have a table of a few thousand people, with a FirstName field
> and a LastName field. Sadly, my people are not so regular. Some names
> have three parts (e.g., due to marriage) crammed into the two fields
> ("Hillary Rodham Clinton"). Some even have titles ("Dir, gastroent.
> dept., Fubar hosp. OurTown") wedged in there. I want to make a web app
> that searches this table incrementally as I type into a web page in my
> browser. I am thinking I will have to do something like continuously
> display the top 10 matches to what I have typed so far. Of course, when I
> am typing I do not know exactly what is in the database. I generally know
> only some of the parts of the name when I am typing (e.g., I am looking up
> "Mary Jones" without knowing whether Jones is her maiden name). Sometimes
> I am even typing something that is a spelled a bit wrong ("Schiller" vs.
> "Shiller") or variantly ("Lizzie" vs. "Elizabeth"). This seems pretty far
> from what MySQL can do directly. I know about "LIKE" matching. I know
> the wider SQL community has something called "soundex", but I have not yet
> found it in MySQL. I have a hard time imagining what will help me with
> variants on a name. I do not see any easy way to find the "top 10"
> matches. Am I missing anything that can help me here?
>
> Thanks in advance!
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
--
- michael dykman
- mdykman@stripped
Don’t worry about people stealing your ideas. If they’re any good,
you’ll have to ram them down their throats!
Howard Aiken
