"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:mspre...@us.ibm.com] >Sent: Monday, September 21, 2009 4:13 PM >To: Martin Gainty >Cc: Jerry Schwartz; 'Michael Dykman'; mysql@lists.mysql.com >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" <jschwa...@the-infoshop.com> >cc >"'Michael Dykman'" <mdyk...@gmail.com>, mysql@lists.mysql.com, Mike >Spreitzer/Watson/i...@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" <jschwa...@the-infoshop.com> >09/21/09 03:47 PM > >To >"'Michael Dykman'" <mdyk...@gmail.com>, Mike Spreitzer/Watson/i...@ibmus >cc ><mysql@lists.mysql.com> >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:mdyk...@gmail.com] >>Sent: Monday, September 21, 2009 12:21 PM >>To: Mike Spreitzer >>Cc: mysql@lists.mysql.com >>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 <mspre...@us.ibm.com> >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=mdyk...@gmail.com >>> >>> >> >> >> >>-- >> - michael dykman >> - mdyk...@gmail.com >> >>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=jschwa...@the- >>infoshop.com > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org