From: Gurhan Ozen
Date: April 29 2002 5:53pm
Subject: RE: What is the best way to do this
List-Archive: http://lists.mysql.com/mysql/107507
Message-Id: <NEBBJFKICMBBMAOHJDFOCEKPDEAA.c-gurhan.ozen@wcom.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit

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:javier@stripped]
Sent: Monday, April 29, 2002 12:53 PM
To: mysql@stripped
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 <mysql-thread107490@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-c-gurhan.ozen=wcom.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php