From: Michael Dykman Date: September 21 2009 4:21pm Subject: Re: incremental name search? List-Archive: http://lists.mysql.com/mysql/218778 Message-Id: <814b9a820909210921i2c721226s6f88e0e2aed0698f@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Perhaps this could help you out.. http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_sound= ex - michael dykman On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer wrot= e: > Suppose I have a table of a few thousand people, with a FirstName field > and a LastName field. =A0Sadly, my people are not so regular. =A0Some nam= es > have three parts (e.g., due to marriage) crammed into the two fields > ("Hillary Rodham Clinton"). =A0Some even have titles ("Dir, gastroent. > dept., Fubar hosp. OurTown") wedged in there. =A0I want to make a web app > that searches this table incrementally as I type into a web page in my > browser. =A0I am thinking I will have to do something like continuously > display the top 10 matches to what I have typed so far. =A0Of course, whe= n I > am typing I do not know exactly what is in the database. =A0I generally k= now > only some of the parts of the name when I am typing (e.g., I am looking u= p > "Mary Jones" without knowing whether Jones is her maiden name). =A0Someti= mes > I am even typing something that is a spelled a bit wrong ("Schiller" vs. > "Shiller") or variantly ("Lizzie" vs. "Elizabeth"). =A0This seems pretty = far > from what MySQL can do directly. =A0I know about "LIKE" matching. =A0I kn= ow > the wider SQL community has something called "soundex", but I have not ye= t > found it in MySQL. =A0I have a hard time imagining what will help me with > variants on a name. =A0I do not see any easy way to find the "top 10" > matches. =A0Am 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: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail= .com > > --=20 - michael dykman - mdykman@stripped Don=92t worry about people stealing your ideas. If they=92re any good, you=92ll have to ram them down their throats! Howard Aiken