What is the best way to do this

[Javier]

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