2021-01-30

sql语句中模糊查询及关键字查询相关练习

–模糊查询[SELECT *FROM 数据表名 WHERE 字段名 LIKE + "%"代表任意字符或 "—"代表一个字符]

–查询名字以a 开始的数据信息
SELECT * FROM students2 WHERE NAME LIKE “a%”;

–查询名字含有a 的数据信息
SELECT * FROM students2 WHERE NAME LIKE “%a%”;
–查询名字仅有两个字符的数据信息
SELECT * FROM students2 WHERE NAME LIKE “——”;

–查询名字至少有两个字符的数据信息
SELECT * FROM students2 WHERE NAME LIKE “%——%”;

–查询id是1或者是4 或者是6的学生信息
SELECT * FROM students2 WHERE id IN (1,4,6);

–查询年龄为18或20的学生信息
SELECT * FROM students2 WHERE age IN (18,21);
–查询年龄不是18或20的学生信息
SELECT * FROM students2 WHERE age NOT IN (18,21);

–查询id为2`~4的学生信息
SELECT * FROM students2 WHERE id between 2 and 4 ;

–查询id是3~5的学生信息,性别为男
SELECT * FROM students2 WHERE （id between 3 and 5）and gender = “男性”;

–查询年龄不在18~20的学生信息
SELECT * FROM students2 WHERE age NOT between 18 and 20 ;