【六祎 -mysql】DQL条件查询关键字 like

######### DQL条件查询关键字 #########
-- 查询id是 1 3 5 7的学生 
SELECT * FROM tb_student02 WHERE id = 1 OR id = 3 OR id = 5 OR id = 7;
SELECT * FROM tb_student02 WHERE id IN ( 1 , 3 ,5 ,7 )
DELETE FROM tb_student02 WHERE id IN ( 2 , 4);

-- 范围查询(包前包后)
SELECT 列名 FROM 表名 WHERE 列名 BETWEEN 小值 AND 大值
-- 查询english成绩大于等于77，且小于等于87的学生
SELECT * FROM tb_student02 WHERE english BETWEEN 77 AND 87;
SELECT * FROM tb_student02 WHERE english >=77 AND english<=87;
SELECT * FROM tb_student02 WHERE english<=87 AND english >=77;


-- like关键字（模糊查询，根据关键字匹配查询）
-- 1.查询出包含马的学生
SELECT * FROM tb_student02 WHERE NAME LIKE '马'; -- 这样是错误的
SELECT * FROM tb_student02 WHERE NAME LIKE '%马%'; -- %代表了匹配任意内容。必须包含马。前后无所谓


-- 需求：查询出不包含马的姓名
SELECT * FROM tb_student02 WHERE NAME NOT LIKE '%马%'; -- %代表了匹配任意内容。必须包含马。前后无所谓
SELECT * FROM tb_student02 WHERE NAME LIKE '%德%'; -- %代表了匹配任意内容。必