List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:September 21 2009 4:21pm
Subject:Re: incremental name search?
View as plain text  
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
Thread
incremental name search?Mike Spreitzer21 Sep
  • Re: incremental name search?Michael Dykman21 Sep
    • RE: incremental name search?Jerry Schwartz21 Sep
      • RE: incremental name search?Martin Gainty21 Sep
      • RE: incremental name search?Mike Spreitzer21 Sep
        • RE: incremental name search?Jerry Schwartz21 Sep
          • RE: incremental name search?Gavin Towey22 Sep
RE: incremental name search?Mike Spreitzer21 Sep
  • RE: incremental name search?Jerry Schwartz21 Sep