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

2025-04-05 20:33:50
推荐回答(2个)
回答1:

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

回答2:

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