MySql (NOT) IN 運算子 (SQL (NOT) IN Operator)

IN 語法 (SQL IN Syntax)

SELECT table_column1, table_column2, table_column3...
FROM table_name
WHERE column_name
IN (value1, value2, value3...);

從下面的 customers 資料表中取得顧客張一或李三的資料

SELECT * FROM `customers` WHERE `Name` IN ('張一', '李三');