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 bferr...@baywinds.org 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 dotage coming upon me


Thanks in advance,

Bruce

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com


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 bferr...@baywinds.orgwrote:

 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://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com




-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com