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:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 12:53 PM
by % % as
patterns and do this:
select row from table2,table3 where fields-m like table3.patterns;
This should work, regards
Jan
- Original Message -
From: Javier [EMAIL PROTECTED]
To: Jan Peuker [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 7:48 PM
Subject: Re: What is the best way to do this
Thanks
]
[EMAIL PROTECTED]
- Original Message -
From: Jan Peuker [EMAIL PROTECTED]
To: Javier [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 9:36 PM
Subject: Re: What is the best way to do this
yep, that's the problem. But MySQL