簡單的 IN 子句

獲取具有任何給定 id 的記錄

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

上面的查詢等於

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