SQL AND,OR,NOT | KingCode Blog

type

status

date

slug

summary

category

icon

password

SQL AND,OR,NOT运算符

该WHERE子句可以与AND,OR,NOT运算符组合使用

AND运算符用于根据OR多个条件过滤记录

AND如果以分隔的所有条件均为TRUE,则运算符显示一条记录AND

OR如果任何由分隔的条件为TRUE,则操作员将显示一条记录OR

NOT如果条件不为真,操作员将显示一条记录

AND语法

SELECT column1,column2,...

FROM TableName

WHERE DataName1 AND DataName2 AND DataName3 ...;

例:

SELECT * FROM TableName WHERE DataName=’Name’ AND IDName=’IDName’;

OR语法

SELECT column1,column2,...

FROM TableName

WHERE DataName1 OR DataName2 OR DataName3 ...;

例:

SELECT * FROM TableName WHERE DataName=’Name’ OR DataName=’Name2’;

NOT语法

SELECT * FROM TableName WHERE NOT DataName;

例:

SELECT * FROM TableName WHERE NOT DataName=’Name12’;

组合AND,OR和NOT运算符

SELECT * FROM TableName

WHERE DataName=’Name’ AND (DataName1=’Name1’ OR DataName2=’Name2’);

SELECT * FROM TableName

WHERE NOT DataName=’Name’ AND NOT DataName1=’Name1’;