说明:COLUMNNAME 列名,TABLENAME 表名
where子句操作符
select COLUMNNAME from TABLENAME where COLUMNNAME 操作符 x;
- =
- <> 、!=
- <
- <=
- >
- >=
between and所需范围的低端值和高端值
select COLUMNNAME from TABLENAME where COLUMNNAME between x and y;
空值检查is null
select COLUMNNAME from TABLENAME where COLUMNNAME is null;