From: Javier
Date: April 29 2002 4:52pm
Subject: What is the best way to do this
List-Archive: http://lists.mysql.com/mysql/107490
Message-Id: <003301c1ef9e$48ec4700$5001010a@internal>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


 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 --