第1个回答 推荐于2018-05-12
id等于1并且等于2 select * from user where id=1 and id=2 //逻辑上说不过
id等于1或者等于2 select * from user where id=1 or id=2
select * from user where id in(1,2)本回答被网友采纳
第2个回答 2011-05-23
SELECT * FROM user WHERE id IN (1 , 2)
第3个回答 2011-05-21
SELECT * FROM `user where id in (1,2)本回答被提问者采纳