independent tables

2011-05-03 Thread Rocio Gomez Escribano
Everyone has his/her own driving license, and I need to know what kind of “person” (client or user) is. mysql select userID, clientID from client, user where (clientCodeDrivingLicense= 321321321 || userCodeDrivingLicense = 321321321); ++---+ | userID | clientID |

Re: Join based upon LIKE

2011-05-03 Thread Johan De Meersman
http://www.gedpage.com/soundex.html offers a simple explanation of what it does. One possibility would be building a referential table with only a recordID and soundex column, unique over both; and filling that with the soundex of individual nonjunk words. So, from the titles 1 | Rain in

RE: Join based upon LIKE

2011-05-03 Thread Jerry Schwartz
-Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Tuesday, May 03, 2011 5:31 AM To: Jerry Schwartz Cc: Jim McNeely; mysql mailing list; Johan De Meersman Subject: Re: Join based upon LIKE http://www.gedpage.com/soundex.html offers a simple explanation of what

Re: Join based upon LIKE

2011-05-03 Thread Johan De Meersman
- Original Message - From: Jerry Schwartz je...@gii.co.jp I'm not sure that I could easily build a dictionary of non-junk words, since The traditional way is to build a database of junk words. The list tends to be shorter :-) Think and/or/it/the/with/like/... Percentages of

MyISAM key length

2011-05-03 Thread shahryar ghazi
Hi, I have a question regarding MyISAM key length in MySQL 5.5.x. Can someone tell me the files (and lines) to modify in order to increase the key length? Thanks. -- Shahryar Ghazi

Re: MyISAM key length

2011-05-03 Thread Claudio Nanni
Hi Sha, I think you need to explain yourself better to have a proper answer. Are you talking about MySQL source code? Claudio 2011/5/3 shahryar ghazi shahryar.gh...@gmail.com Hi, I have a question regarding MyISAM key length in MySQL 5.5.x. Can someone tell me the files (and lines) to

Re: MyISAM key length

2011-05-03 Thread shahryar ghazi
Yes, I was talking about modifying MySQL source code. Thanks. On Tue, May 3, 2011 at 10:46 AM, Claudio Nanni claudio.na...@gmail.comwrote: Hi Sha, I think you need to explain yourself better to have a proper answer. Are you talking about MySQL source code? Claudio 2011/5/3 shahryar

Re: Join based upon LIKE

2011-05-03 Thread shawn wilson
I'm actually enjoying this discussion because I have the same type of issue. However, I have done away with trying to do a full text search in favor of making a table with unique fields where all fields should uniquely identify the group. If I get a dupe, I can clean it up. However, like you,

RE: Join based upon LIKE

2011-05-03 Thread Jerry Schwartz
My situation is sounds rather simple. All I am doing is matching a spreadsheet of products against our database. My job is to find any matches against existing products and determine which ones are new, which ones are replacements for older products, and which ones just need to have the

Re: Join based upon LIKE

2011-05-03 Thread Nuno Tavares
Dear Jerry, I've been silently following this discussion because I've missed the original question. But from your last explanation, now it really looks you have a data quality kind of issue, which is by far related with MySQL. Indeed, in Data Quality, there is *never* a ready solution, because

How do I get more pages in mySQL Workbench?? WAS: Any table visualization tools with wires connecting the actual columns?

2011-05-03 Thread Daevid Vincent
I just discovered that MySQL Workbench actually WILL connect columns. Use the #6 wire type shortcut (bottom one). However, I must be retarded or blind because I can't figure out how to make the diagram have more than the default of 2 pages. I have a database with 50 tables and they just don't