MySQL各类查询语句DQL------like-in- between

建表语句

CREATE TABLE `class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createdate` datetime DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `pwd` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `age` int(3) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `introduce` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

插入数据

INSERT into student VALUES(0,'2024-02-25','香菱','123','15614333260',18,'女','万民堂大厨');
INSERT into student VALUES(0,'2024-02-25','凝光','123','15614333260',26,'女','璃月七星天权星');
INSERT into student VALUES(0,'2024-02-25','刻晴','123','15614333260',23,'女','璃月七星玉衡星');
INSERT into student VALUES(0,'2024-02-25','北斗','123','15614333260',26,'女','大船长');
INSERT into student VALUES(0,'2024-02-25','胡桃','123','15614333260',18,'女','往生堂第77代堂主');
SELECT * FROM student;

查询语句

# like的使用语法，where后先写查询列再写like，最后写匹配字符串
SELECT * FROM class where username like '刻%';
# 模糊查询基本上所有后台管理系统都有此功能
SELECT * FROM class where pwd is not null;
# 范围查询between and 包含==，既可以查询数值范围，也可以查询时间范围。
SELECT * from class where age between 20 and 26;
# in 关键字的使用，不建议使用这个关键字，因为它不一定走索引，在百万表的数据中会很卡。
SELECT * from class WHERE username in (‘香菱’);