where条件字句
作用:检查搜索数据中符合条件的值
逻辑运算符
运算符 | 语法 | 描述 |
---|---|---|
and && | a and b a&&b | 逻辑与,两个都为真,结果为真 |
or ll | a or b a ll b | 逻辑或,其中一个为真,则结果为真 |
Not ! | not a !a | 逻辑非,真为假,假为真! |
SELECT `StudentNo`,`StudentResult` FROM result
-- 查询考试成绩在60~80之间
SELECT `studentNo`,`StudentResult` FROM result
WHERE `StudentResult`>=60 AND `StudentResult`<=80
SELECT `StudentNo`,`StudentResult` FROM result
WHERE `StudentResult`>=50 && `StudentResult`<=70
-- 模糊查询(区间)
SELECT `StudentNo`,`StudentResult` FROM result
WHERE `StudentResult` BETWEEN 60 AND 85
-- 除了1000号学生之外的同学的成绩
SELECT `StudentNo`,`StudentResult` FROM result
WHERE `StudentNo` != 1000
SELECT `StudentNo`,`StudentResult` FROM result
WHERE NOT `StudentNo`=1000