List:General Discussion« Previous MessageNext Message »
From:Gurhan Ozen Date:April 29 2002 5:53pm
Subject:RE: What is the best way to do this
View as plain text  
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

Thread
What is the best way to do thisJavier29 Apr
  • RE: What is the best way to do thisGurhan Ozen29 Apr
  • Re: What is the best way to do thisJan Peuker29 Apr
  • Re: What is the best way to do thisGelu29 Apr