You can write a program to do this.. Just query the table one , and tokenize the string returned and query the second table for each token with LIKE clauses and wildcards in a loop.
Gurhan -----Original Message----- From: Javier [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 12:53 PM To: [EMAIL PROTECTED] Subject: What is the best way to do this Hi everybody, I need do the following: I have two MySQL tables, Table1 . . field-n . . Table2 . . field-m . . <field-n> and <field-m> are both varchar(100) containing words separated by space. I need to find out if any of the words in <field-n> also are in <field-m>. Is it possible to do that? What is the best way for it? Thanks Javier Diaz IT Developer - Scanned for all known viruses by Messagelabs -- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
