in 运算符,比较同属性的一系列值可以用
/*获取位于va,fl,ga的顾客,合并条件*/
/*SELECT *
FROM customers
WHERE state='va' OR state='fl' OR state='ga'*/
SELECT *
FROM customers
WHERE state IN ('va','fl','ga')#括号中内容的先后顺序无所谓
not in 运算符
SELECT *
FROM customers
WHERE state NOT IN ('va','fl','ga')#括号中内容的先后顺序无所谓