实例 PostgreSQL 使用 IN 运算符实例

 
SELECT * FROM cars
WHERE brand IN ('Volvo', 'Mercedes', 'Ford');        
                    

输出结果

 brand | model   | year
-------+---------+------
 Ford  | Mustang | 1964
 Volvo | p1800   | 1968
(2 rows)