ELECT * FROM student where Username like '杨%';
SELECT * FROM student where Username like '%大%';
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 ('赵灵儿','杨过','龙姑娘');
MySQL
最新推荐文章于 2024-08-06 17:49:28 发布
文章介绍了使用SQL查询从student表中筛选特定条件的数据,包括按姓名首字、全名匹配、日期范围以及多值查询等方法。
摘要由CSDN通过智能技术生成