SQL指南-IN
IN
IN 运算符可用于如果你知道一列你所想返回的精确值。
SELECT column_name FROM table_name WHERE column_name IN (value1,value2,..) |
-------------------------------------------
原始表 (用于示例)
LastName | FirstName | Address | City |
---|---|---|---|
Hansen | Ola | Timoteivn 10 | Sandnes |
Nordmann | Anna | Neset 18 | Sandnes |
Pettersen | Kari | Storgt 20 | Stavanger |
Svendson | Tove | Borgvn 23 | Sandnes |
-------------------------------------------
示例 1
使用下面的SQL语显示LastName 等于"Hansen" 或者"Pettersen"的人 :
SELECT * FROM Persons WHERE LastName IN ('Hansen','Pettersen') |
返回结果:
LastName | FirstName | Address | City |
---|---|---|---|
Hansen | Ola | Timoteivn 10 | Sandnes |
Pettersen | Kari | Storgt 20 | Stavanger |