#模糊查询like,以后只要写表搜索必写的一个sql语句
select * from student where age like '%200%';
#空查询
select * from student where pwd is null;
#范围查询between 小数值 and 大数值
select * from student where age between 150 and 200;
#in关键字,非必要不建议使用,一般不走索引,数据量超过百万就很卡。
select * from student where userName in ('神农','仓颉','盘古');
select * from student where userName not in ('女娲','蚩尤');