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

说明：COLUMNNAME 列名，TABLENAME 表名

and操作符

select COLUMNNAME from TABLENAME where COLUMNNAME >= x and COLUMNNAME <=y;

or操作符

select COLUMNNAME from TABLENAME where COLUMNNAME >= x or COLUMNNAME <=y;

in操作符=or

select COLUMNNAME from TABLENAME where COLUMNNAME in(x,y);

not操作符

select COLUMNNAME from TABLENAME where COLUMNNAME not in(x,y);

常见not in \ not between \ not exitsts