Question

SQL语句查询条件一个字段＝多个值怎么写

如题：select * from otim where sheetid=1如果我要查多个条件、1、2、3、要怎么写呢？小弟诚心请教！

Answer 1

用in随便你写多少，记得中间用逗号隔开
SELECT * FROM otim WHERE sheetid IN (1,2,3,4);

Answer 2

select * from otim where sheetid between 1 and 3;或者