【数据库复习笔记】2.where的用法

1- 比较运算符=、!=/<>、>、>=、<、<=
2- 字符串为a=""或a=’’
delete from student where name=’jack’;
3- 字符串中不区分大小写！！！where log= ‘Aaa’可以得出’AAA’
4- and or
and连接两个条件，表示两个条件必须同时满足，结果才满足。
delete from student where gender=’男’ and age > 25;
or 连接两个条件，表示其中任意一个条件成立，结果就成立。
delete from student where sno = 1 or sno = 2 or sno = 3;
5- between min_val and max_val表示一段范围
delete from student score between 80 and 90;
等同于delete from student where score >= 80 and score <= 90;
6- null
delete from student where tel = null;
delete from student where tel is null;
7- not 表示取反
ex:删除分数不在80到90之间所有学生的信息
delete from student where score not between 80 and 90;
ex:删除学号不为1， 2， 3的所有学生信息
delete from student where sno not in (1, 2, 3);
ex:删除电话不为null的所有学生信息
delete from student where tel is not null;
8- like 模糊查询 %零个或者多个字符 表示有且仅有一个字符
可以通过escape标示符实现对 % 本身这两个字符的查找
select * from emp where ename like ‘%/_%’ escape ‘/’;
使用转义符，可以把通配符改变成普通字符。2种方法：
1、[]是默认的转义符，里面的通配符（里面只能是通配符），都当做普通字符处理：like ‘dsd[%]’，这时，%就是个普通字符了，查找条件就是要某个字段值完全等于 dsd% 。
2、用ESCAPE关键字定义转义符，like ‘dsd/%’ ESCAPE ‘/’ 效果同 like ‘dsd[%]’