Mysql Multiple Arguments for "Where" Clause

Question

I just want to ask if it is possible to have multiple arguments for, where clause in mysql?

Something like:

SELECT * from tblId where id=1,2,3,4

Supposed I only want to select id's 1,2,3,4. I tried this but give me error. Thanks for the help :)

Neigyl R. Noval · Accepted Answer · 2013-06-06 09:56:28Z

7

SELECT * FROM tblId WHERE id IN (1, 2, 3, 4);

answered Jun 6, 2013 at 9:56

Neigyl R. Noval

6,0584 gold badges29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pritesh Tayade · Accepted Answer · 2013-06-06 09:56:50Z

2

Try this query:

SELECT * from tblId where id in (1,2,3,4)

answered Jun 6, 2013 at 9:56

Pritesh Tayade

6404 silver badges11 bronze badges

Comments

xlecoustillier · Accepted Answer · 2013-06-06 09:56:33Z

1

Try in:

SELECT * from tblId where id in (1,2,3,4)

answered Jun 6, 2013 at 9:56

xlecoustillier

16.4k15 gold badges64 silver badges88 bronze badges

Comments

Samit · Accepted Answer · 2013-06-06 10:02:14Z

-4

Try this SELECT * from tblId where id =1 and id =2 and id =3 and id =4

answered Jun 6, 2013 at 10:02

Samit

1

3 Comments

Taryn Over a year ago

id could never equal 1, 2, 3, and 4 at the same time.

peixe Over a year ago

You should do it with an OR instead of the AND, I guess... Anyway, this is not the optimal way.

Samit Over a year ago

sorry for the mistake, it should be OR. but this is the simplest if u need immediate fix or dont know the syntax of a new database for '.... in (1,2,3,4)'

Collectives™ on Stack Overflow

Mysql Multiple Arguments for "Where" Clause

4 Answers 4

Comments

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related