MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: I'm looking for the best way to join two tables based on the matching of the words in a varchar field in one table against a varchar field on another table
Posted by: Rick James
Date: July 01, 2009 07:55PM

Let's do it another way...
Add an extra column to each table. Set it to the words in alphabetical order, in lower case. (Also remove punctuation, put exactly one space between words, and anything else to make it "canonical".)
Then INDEX that column in each table.
Poof, it is a simple, efficient, JOIN on that column.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
I'm looking for the best way to join two tables based on the matching of the words in a varchar field in one table against a varchar field on another table
3821
Edgardo Grinblat
June 30, 2009 10:38AM
Re: I'm looking for the best way to join two tables based on the matching of the words in a varchar field in one table against a varchar field on another table
1921
Rick James
July 01, 2009 07:55PM
Re: I'm looking for the best way to join two tables based on the matching of the words in a varchar field in one table against a varchar field on another table
1818
Edgardo Grinblat
July 02, 2009 06:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.