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=arch...@jab.org
RE: incremental name search?
agreed better to know which languages you'll support and load in the correct charset up front retro-fitting an existing DB to another charset can be time consuming and error-prone e.g. # Convert all tables to UTF-8 with binary collation and reset all char columns to correct width ALTER TABLE user MODIFY Host char(60) NOT NULL default '', MODIFY User char(16) NOT NULL default '', ENGINE=MyISAM, CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin; # much better: USE Database SET character_set_client = utf8; CREATE Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant 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 search? Date: Mon, 21 Sep 2009 15:47:20 -0400 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=mgai...@hotmail.com _ Ready for Fall shows? Use Bing to find helpful ratings and reviews on digital tv's. http://www.bing.com/shopping/search?q=digital+tv'sform=MSHNCBpubl=WLHMTAGcrea=TEXT_MSHNCB_Vertical_Shopping_DigitalTVs_1x1
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
RE: incremental name search?
These are namestitles 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
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: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 namestitles 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
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: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 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
RE: incremental name search?
Last time I did this for a small app, I just selected all the names and returned 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: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 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: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 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=gto...@ffn.com