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
