MySQL 常用语句查询语句

SELECT * FROM `student`where userName like '杨_';
SELECT * FROM `student`where userName like '杨%';
SELECT * FROM `student`where pwd is null ;
SELECT * FROM `student`where  pwd is not null ;
SELECT * FROM `student`where age between 20 and 30;
SELECT * FROM `student`where createDate between '2024-02-21 00:00:00'and  '2024-02-25 00:00:00';
SELECT * FROM `student`where userName in ('赵灵儿','杨过','龙姑娘');