Odd select question

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=gcdmg-mysql-2@m.gmane.org

Re: Odd select question

--0016e6d7ef3850b97b0475c23e17
Content-Type: text/plain; charset=ISO-8859-1

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 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=jlyons4435@gmail.com
>
>


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

--0016e6d7ef3850b97b0475c23e17--

Re: Odd select question

--00c09ffb5b058b29f40475c24282
Content-Type: text/plain; charset=ISO-8859-1

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 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.nanni@gmail.com

--00c09ffb5b058b29f40475c24282--