【MySQL必知必会】第六章 过滤数据（学习笔记）

说明：COLUMNNAME 列名，TABLENAME 表名

where子句操作符

select COLUMNNAME from TABLENAME where COLUMNNAME 操作符 x;

1. =
2. <> 、!=
3. <
4. <=
5. >
6. >=

between and所需范围的低端值和高端值

select COLUMNNAME from TABLENAME where COLUMNNAME between x and y;

空值检查is null

select COLUMNNAME from TABLENAME where COLUMNNAME is null;