SQL 基础教程

• SQL 基础命令

SQL 高级教程

• SQL Top
• SQL Like
• SQL 通配符
• SQL In
• SQL Between
• SQL Alias
• SQL JOIN
• SQL Union

SQL IN 操作符

---

IN 操作符

IN 操作符允许我们在 WHERE 子句中规定多个值。

SQL IN 语法

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)

---

实例：

mysql> select * from persons;
+----------+----------+-----------+----------------+----------+
| PersonID | LastName | FirstName | Address        | City     |
+----------+----------+-----------+----------------+----------+
|        1 | Adams    | John      | Oxford Street  | London   |
|        2 | Bush     | George    | Fifth Avenue   | New York |
|        3 | Carter   | Thomas    | Changan Street | Beijing  |
+----------+----------+-----------+----------------+----------+
3 rows in set (0.02 sec)

mysql> select * from persons where personid in (1,2);
+----------+----------+-----------+---------------+----------+
| PersonID | LastName | FirstName | Address       | City     |
+----------+----------+-----------+---------------+----------+
|        1 | Adams    | John      | Oxford Street | London   |
|        2 | Bush     | George    | Fifth Avenue  | New York |
+----------+----------+-----------+---------------+----------+