模糊查询like,between-and

查询

#like的使用语法，where后先写查询列再写like,最后写匹配字符串
SELECT * FROM student where userName like '杨_';
select * from student where userName like '杨%';
select * from student where introduce like '%大%';
#模糊查询基本上所有后台管理系统都会此功能
select * from student where pwd is not null;
select * from student where age between 22 and 30;