Re: Odd select question

2009-10-12 Thread Jim Lyons
that's legal where "set" is a comma-delimited list of items of the same datatype as "col1" On Mon, Oct 12, 2009 at 2:41 PM, Bruce Ferrell wrote: > I seem to recall a SQL select syntax along these lines: > > SELECT col1, col2 > WHERE col1 IN (set) > > Is this or similar syntax in MySQL or is my do

Re: Odd select question

2009-10-12 Thread Claudio Nanni
There is! But I would definitely check the online doc for further and more complete info. Cheers! Claudio On Oct 12, 2009 9:47 PM, "Bruce Ferrell" wrote: I seem to recall a SQL select syntax along these lines: SELECT col1, col2 WHERE col1 IN (set) Is this or similar syntax in MySQL or is my d

Odd select question

2009-10-12 Thread Bruce Ferrell
I seem to recall a SQL select syntax along these lines: SELECT col1, col2 WHERE col1 IN (set) Is this or similar syntax in MySQL or is my dotage coming upon me Thanks in advance, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis