Select multiple rows with multiple matching id(s)

Question

Is there a way to query data to display multiple rows with multiple selector?

like:

SELECT * FROM `book` WHERE `book`.id = 1 AND `book`.id = 2;

table:

id name
1  book1
2  book2
3  book3
4  book4

I dun suppose looping for each id is favourable.

Assuming you are using backticks to escape identifiers, I am tagging this question with mysql RDBMS tag. — souslov
– souslov, Commented Jun 27, 2015 at 22:35

souslov · Accepted Answer · 2015-06-27 22:32:25Z

3

Well, yeah, you can use in, but this is the same as multiple or, not and – one value can't be equal to the two unequal values at once:

select *
from `book`
where `book`.id in(1, 2)

answered Jun 27, 2015 at 22:32

souslov

44.7k11 gold badges92 silver badges113 bronze badges

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

Comments

GolezTrol · Accepted Answer · 2015-06-27 22:33:51Z

2

One solution you have, but you made an error. An id cannot be both 1 and 2, so you need to use OR to return those rows that are either 1 or 2.

SELECT * FROM `book` WHERE `book`.id = 1 OR `book`.id = 2;

A slightly simpler notation would be:

SELECT * FROM `book` WHERE `book`.id in (1, 2);

answered Jun 27, 2015 at 22:33

GolezTrol

116k19 gold badges186 silver badges215 bronze badges

Collectives™ on Stack Overflow

Select multiple rows with multiple matching id(s)

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related