MySQL 'IN' Operator Syntax

[Obi Wan Shinobi]

Hello,

I'm learning about MySQL but i'm having problems with the 'IN'
operator. For example:

SELECT * FROM TABLE_NAME WHERE ID = IN ('9','19','3','10');

....gives me a syntax error. I've also tried it with (9,19,3,10) but it
gives me the same problem.

I have a feeling i'm missing something very simple.

Any pointers would be greatly appreciated.

Many Thanks.

[Chris Hope]

Obi Wan Shinobi wrote:

I'm learning about MySQL but i'm having problems with the 'IN'
operator. For example:

SELECT * FROM TABLE_NAME WHERE ID = IN ('9','19','3','10');

...gives me a syntax error. I've also tried it with (9,19,3,10) but it
gives me the same problem.

Get rid of the = so it reads like:

SELECT * FROM TABLE_NAME WHERE ID IN (9,19,3,10);

Chris

--
Chris Hope
The Electric Toolbox Ltd
http://www.electrictoolbox.com/

[Chris Hope]

Obi Wan Shinobi wrote:

I'm learning about MySQL but i'm having problems with the 'IN'
operator. For example:

SELECT * FROM TABLE_NAME WHERE ID = IN ('9','19','3','10');

...gives me a syntax error. I've also tried it with (9,19,3,10) but it
gives me the same problem.

Get rid of the = so it reads like:

SELECT * FROM TABLE_NAME WHERE ID IN (9,19,3,10);

Chris

--
Chris Hope
The Electric Toolbox Ltd
http://www.electrictoolbox.com/

[Chris Hope]

Obi Wan Shinobi wrote:

I'm learning about MySQL but i'm having problems with the 'IN'
operator. For example:

SELECT * FROM TABLE_NAME WHERE ID = IN ('9','19','3','10');

...gives me a syntax error. I've also tried it with (9,19,3,10) but it
gives me the same problem.

Get rid of the = so it reads like:

SELECT * FROM TABLE_NAME WHERE ID IN (9,19,3,10);

Chris

--
Chris Hope
The Electric Toolbox Ltd
http://www.electrictoolbox.com/

[Bill Karwin]

Obi Wan Shinobi wrote:

SELECT * FROM TABLE_NAME WHERE ID = IN ('9','19','3','10');

Don't use = with IN. For example:
SELECT * FROM TABLE_NAME WHERE ID IN ('9','19','3','10');

See http://dev.mysql.com/doc/mysql/en/Co...Operators.html, this
lists all the syntax for comparison operations.

Regards,
Bill K.