List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:September 21 2009 9:29pm
Subject:RE: incremental name search?
View as plain text  
"Approximate" things are something humans are very good at, but computers are 
not. I'll bet a Rolodex would be faster than a web-based application.

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: Mike Spreitzer [mailto:mspreitz@stripped]
>Sent: Monday, September 21, 2009 4:13 PM
>To: Martin Gainty
>Cc: Jerry Schwartz; 'Michael Dykman'; mysql@stripped
>Subject: RE: incremental name search?
>
>These are names&titles of Americans.  This web app and database do not
>exist now (the current procedure is done with more primitive tech), and so
>I can make plausible adjustments to the plan.
>
>Thanks
>
>
>
>Mike Spreitzer/Watson/IBM
>09/21/09 04:10 PM
>
>To
>"Jerry Schwartz" <jschwartz@stripped>
>cc
>"'Michael Dykman'" <mdykman@stripped>, mysql@stripped, Mike
>Spreitzer/Watson/IBM@IBMUS
>Subject
>RE: incremental name search?
>
>
>
>
>
>Ah, yes, I forgot to describe the server and the load.  Suppose my web app
>and MySQL are done via shared hosting by some common hosting business.  I
>do expect multiple people to be using my web app, but generally only one
>(usually zero, sometimes one, maybe occasionally a few) at a time.  Is
>this going to fly, in terms of latency for the incremental lookups and
>overall load at the hosting site?
>
>Thanks
>
>
>
>
>"Jerry Schwartz" <jschwartz@stripped>
>09/21/09 03:47 PM
>
>To
>"'Michael Dykman'" <mdykman@stripped>, Mike Spreitzer/Watson/IBM@IBMUS
>cc
><mysql@stripped>
>Subject
>RE: incremental name search?
>
>
>
>
>
>
>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
>
>
>
>
>
>




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