List:General Discussion« Previous MessageNext Message »
From:Fred Lindberg Date:April 12 1999 5:23pm
Subject:Re: Problems with in
View as plain text  
On Mon, 12 Apr 1999 17:14:39 +0000, Thomas Booms EDV wrote:

>Is this function not implemented ?
AFAIK, no.

>How can I do it?
I've used SELECT value3 FROM table3, then just built 'res1','res2', ...
in the application and used it in the next query:

SELECT value1 from table2 WHERE value2 IN ('res1','res2',...)

The MySQL folks are working on subselects, though.

If the list of value3 matches is very long, you could achieve the same
with a JOIN between table1 and table3.
-Sincerely, Fred

(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)

Problems with inThomas Booms EDV12 Apr
Re: Problems with inFred Lindberg12 Apr
Re: Problems with inTomislav Petrovic12 Apr