简单的 IN 子句

获取具有任何给定 id 的记录

select * 
from products
where id in (1,8,3)

上面的查询等于

select * 
from products
where id = 1
   or id = 8
   or id = 3