SoundEx doesn't do much for names, or non-English words for that matter.
Although you could use AJAX to handle the web part of this, I can't imagine it
being able to handle much of a load. I think you'll beat the system to death,
to little avail.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
>-----Original Message-----
>From: Michael Dykman [mailto:mdykman@stripped]
>Sent: Monday, September 21, 2009 12:21 PM
>To: Mike Spreitzer
>Cc: mysql@stripped
>Subject: Re: incremental name search?
>
>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
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>infoshop.com
