The IN Operator | IN 运算符 | MySQL

学习IN 和 NOT IN

使用运算符IN，来返回和下述代码一样的值

IN

代码一

SELECT *
FROM Customers
WHERE  state = 'VA' OR state = 'GA' OR state = 'FL';

代码二（使用IN，代码更简洁）

SELECT *
FROM Customer
WHERE state IN ('VA','FL','GA');

NOT IN

得到上述结果的取反

SELECT *
FROM Customer
WHERE state NOT IN ('VA','FL','GA');

练习

返回质量是49，38，72的产品

SELECT *
FROM products
WHERE quantity_in_stock in (49,38,72);

结果