Question

sql 语句查找某字段等于多个可能值

SELECT * FROM `order_status` WHERE order_status_id='?'

我想查找 order_status_id 为3或16的 应该怎么写呢？谢谢

哪个高效啊？

Answer 1

2种写法
1)
SELECT * FROM `order_status` WHERE order_status_id= 3 OR order_status_id = 16
2)
SELECT * FROM `order_status` WHERE order_status_id IN (3, 16)

Answer 2

用 in
SELECT * FROM `order_status` WHERE order_status_id in(3,6)

Answer 3

WHERE order_status_id=3 or order_status_id=16

Answer 4

楼上的说的 OR 或In 都可以，它们的效率是一样的，只是In更加简洁些