incremental name search?

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=gcdmg-mysql-2@m.gmane.org

Re: incremental name search?

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@gmail.com

Don=92t worry about people stealing your ideas. If they=92re any good,
you=92ll 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=3Dgcdmg-mysql-2@m.gmane.o rg

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@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.htm l#function_soundex
>
> - michael dykman
>
>On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer 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=mdykman@gmail.com
>>
>>
>
>
>
>--
> - michael dykman
> - mdykman@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=jschwartz@the-
>infoshop.com





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: incremental name search?

--_25d74fb2-d7b9-462f-a3d1-5c685123764b_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


agreed

better to know which languages you'll support and load in the correct chars=
et up front
retro-fitting an existing DB to another charset can be time consuming and e=
rror-prone e.g.

# Convert all tables to UTF-8 with binary collation and reset all char colu=
mns to correct width
ALTER TABLE user
MODIFY Host char(60) NOT NULL default ''=2C
MODIFY User char(16) NOT NULL default ''=2C
ENGINE=3DMyISAM=2C CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin=3B

# much better:
USE Database
SET character_set_client =3D utf8=3B
CREATE

Martin Gainty=20
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=
=E9
=20
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
..




> From: jschwartz@the-infoshop.com
> To: mdykman@gmail.com=3B mspreitz@us.ibm.com
> CC: mysql@lists.mysql.com
> Subject: RE: incremental name search?
> Date: Mon=2C 21 Sep 2009 15:47:20 -0400
>=20
> SoundEx doesn't do much for names=2C or non-English words for that matter=
..
>=20
> Although you could use AJAX to handle the web part of this=2C I can't ima=
gine it=20
> being able to handle much of a load. I think you'll beat the system to de=
ath,
> to little avail.
>=20
> Regards=2C
>=20
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington=2C CT 06032
>=20
> 860.674.8796 / FAX: 860.674.8341
>=20
> www.the-infoshop.com
>=20
> >-----Original Message-----
> >From: Michael Dykman [mailto:mdykman@gmail.com]
> >Sent: Monday=2C September 21=2C 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.htm l#function_so=
undex
> >
> > - michael dykman
> >
> >On Mon=2C Sep 21=2C 2009 at 11:51 AM=2C Mike Spreitzer com> wrote:
> >> Suppose I have a table of a few thousand people=2C with a FirstName fi=
eld
> >> and a LastName field. Sadly=2C my people are not so regular. Some na=
mes
> >> have three parts (e.g.=2C due to marriage) crammed into the two fields
> >> ("Hillary Rodham Clinton"). Some even have titles ("Dir=2C gastroent.
> >> dept.=2C 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=2C =
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.=2C I am look=
ing up
> >> "Mary Jones" without knowing whether Jones is her maiden name). Somet=
imes
> >> I am even typing something that is a spelled a bit wrong ("Schiller" v=
s.
> >> "Shiller") or variantly ("Lizzie" vs. "Elizabeth"). This seems pretty=
far
> >> from what MySQL can do directly. I know about "LIKE" matching. I kno=
w
> >> the wider SQL community has something called "soundex"=2C but I have n=
ot yet
> >> found it in MySQL. I have a hard time imagining what will help me wit=
h
> >> 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=3Dmdykman@gmail.=
com
> >>
> >>
> >
> >
> >
> >--
> > - michael dykman
> > - mdykman@gmail.com
> >
> >Don't worry about people stealing your ideas. If they're any good=2C
> >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=3Djschwartz@the-
> >infoshop.com
>=20
>=20
>=20
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@hotmail.c=
om
>=20

____________________________________________________________ _____
Ready for Fall shows? Use Bing to find helpful ratings and reviews on digit=
al tv's.
http://www.bing.com/shopping/search?q=3Ddigital+tv's&form=3D MSHNCB&publ=3DW=
LHMTAG&crea=3DTEXT_MSHNCB_Vertical_Shopping_DigitalTVs_1x1=

--_25d74fb2-d7b9-462f-a3d1-5c685123764b_--

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"
09/21/09 03:47 PM

To
"'Michael Dykman'" , Mike Spreitzer/Watson/IBM@IBMUS
cc

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@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.htm l#function_soundex
>
> - michael dykman
>
>On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer
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=mdykman@gmail.com
>>
>>
>
>
>
>--
> - michael dykman
> - mdykman@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=jschwartz@the-
>infoshop.com







--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

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"
cc
"'Michael Dykman'" , mysql@lists.mysql.com, 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"
09/21/09 03:47 PM

To
"'Michael Dykman'" , Mike Spreitzer/Watson/IBM@IBMUS
cc

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@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.htm l#function_soundex
>
> - michael dykman
>
>On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer
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=mdykman@gmail.com
>>
>>
>
>
>
>--
> - michael dykman
> - mdykman@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=jschwartz@the-
>infoshop.com








--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: incremental name search?

"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@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"
>cc
>"'Michael Dykman'" , mysql@lists.mysql.com, 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"
>09/21/09 03:47 PM
>
>To
>"'Michael Dykman'" , Mike Spreitzer/Watson/IBM@IBMUS
>cc
>
>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@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.ht ml#function_soundex
>>
>> - michael dykman
>>
>>On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer
>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=mdykman@gmail.com
>>>
>>>
>>
>>
>>
>>--
>> - michael dykman
>> - mdykman@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=jschwartz@the-
>>infoshop.com
>
>
>
>
>
>





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: incremental name search?

Beyond being leery of the whole project, I can't really say how well or poorly
it would work. You are, after all, talking about at least one query per
keystroke. On top of that you're going to be doing some tricky stuff in a PHP
(or some such) back-end, to figure out what query to use - again, one
execution per keystroke.

It doesn't matter if it's only one user, if they type fast enough it will
generate many server hits: several per second, I should think.

I wonder how Google handles their search suggestion gimmick - I never gave it
much thought. That's as close as I can come to a similar application, off the
top of my head.

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@us.ibm.com]
>Sent: Monday, September 21, 2009 4:11 PM
>To: Jerry Schwartz
>Cc: 'Michael Dykman'; mysql@lists.mysql.com; Mike Spreitzer
>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"
>09/21/09 03:47 PM
>
>To
>"'Michael Dykman'" , Mike Spreitzer/Watson/IBM@IBMUS
>cc
>
>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@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.ht ml#function_soundex
>>
>> - michael dykman
>>
>>On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer
>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=mdykman@gmail.com
>>>
>>>
>>
>>
>>
>>--
>> - michael dykman
>> - mdykman@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=jschwartz@the-
>>infoshop.com
>
>
>
>
>





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: incremental name search?

Last time I did this for a small app, I just selected all the names and ret=
urned them as a javascript array. All the auto-complete as you type logic =
was just done in the UI. If the list is large-ish you could simply have a =
cron process that creates a .js file which the web page would include.

Regards,
Gavin Towey

-----Original Message-----
From: Jerry Schwartz [mailto:jschwartz@the-infoshop.com]
Sent: Monday, September 21, 2009 2:29 PM
To: 'Mike Spreitzer'
Cc: 'Michael Dykman'; mysql@lists.mysql.com
Subject: RE: incremental name search?

Beyond being leery of the whole project, I can't really say how well or poo=
rly
it would work. You are, after all, talking about at least one query per
keystroke. On top of that you're going to be doing some tricky stuff in a P=
HP
(or some such) back-end, to figure out what query to use - again, one
execution per keystroke.

It doesn't matter if it's only one user, if they type fast enough it will
generate many server hits: several per second, I should think.

I wonder how Google handles their search suggestion gimmick - I never gave =
it
much thought. That's as close as I can come to a similar application, off t=
he
top of my head.

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@us.ibm.com]
>Sent: Monday, September 21, 2009 4:11 PM
>To: Jerry Schwartz
>Cc: 'Michael Dykman'; mysql@lists.mysql.com; Mike Spreitzer
>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"
>09/21/09 03:47 PM
>
>To
>"'Michael Dykman'" , Mike Spreitzer/Watson/IBM@IBMUS
>cc
>
>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@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.ht ml#function_sou=
ndex
>>
>> - michael dykman
>>
>>On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer
>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=3Dmdykman@gmail.c=
om
>>>
>>>
>>
>>
>>
>>--
>> - michael dykman
>> - mdykman@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=3Djschwartz@the-
>>infoshop.com
>
>
>
>
>





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com


The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg