RE: incremental name search?

2009-09-21 Thread Gavin Towey
. Regards, Gavin Towey -Original Message- From: Jerry Schwartz [mailto:jschwa...@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

RE: incremental name search?

2009-09-21 Thread Jerry Schwartz
zer [mailto:mspre...@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 &g

RE: incremental name search?

2009-09-21 Thread Jerry Schwartz
X: 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: incrementa

RE: incremental name search?

2009-09-21 Thread Mike Spreitzer
uot;'Michael Dykman'" , 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

RE: incremental name search?

2009-09-21 Thread Mike Spreitzer
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/i...@ibmus cc Subject RE: incremental name search? SoundEx doe

RE: incremental name search?

2009-09-21 Thread Martin Gainty
t donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: jschwa...@the-infoshop.com > To: mdyk...@gmail.com; mspre...@us.ibm.com > CC: mysql@lists.mysql.com > Subject: RE: incremental name s

RE: incremental name search?

2009-09-21 Thread Jerry Schwartz
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 wrote: >> Su

Re: incremental name search?

2009-09-21 Thread Michael Dykman
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 wrote: > Suppose I have a table of a few thousand people, with a FirstName field > and a LastName field.  Sadly, my

incremental name search?

2009-09-21 Thread Mike Spreitzer
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