目录
一、简单条件查询
案例:#查询学号大于2019443800的学生
SELECT
*
FROM `hel_selection_info`
WHere s_code>2019443800
二、逻辑与算法(or和and)
作用:or和and
案例:查询学号在2019443800到2019444000
SELECT
*
FROM `hel_selection_info`
WHere s_code>=2019443800 and s_code<=2019444000
案例:查找学号在2019443800到2019444000或者班级是大数据19-03班的的学生
SELECT
*
FROM
`hel_student_info`
WHere
not(s_code>=2019443800 and s_code<=2019444000) or s_grade="大数据2019-03";
三、模糊查询
3.1:(LIKE)
案例:查询某字段数据中含有“数”的学生信息
SELECT
*
FROM `hel_student_info`
WHere s_grade LIKE "%数%";
案例二:查询第二个字符是数,第是个数据是2的学生学号
SELECT
s_code,s_name
FROM
`hel_student_info`
WHere
s_grade LIKE "_数_2%";
当文件中出现_与转义符相同时,需要设置新的转义符
3.2:between and
案例:查询学号在2019443800到2019444000的学生名字和班级
SELECT
s_name,s_grade
FROM `hel_student_info`
WHere
s_code BETWEEN 2019443800 and 2019444000;
3.3:IN
案例:查询班级是大数据2019-03或者大数据2019-04的学生的学号和名字
-- 查询班级是大数据2019-03或者大数据2019-04的学生的学号和名字
SELECT
s_name,s_code
FROM `hel_student_info`
WHere
s_grade="大数据2019-03"or s_grade="大数据2019-04";
SELECT
s_name,s_code
FROM `hel_student_info`
WHere
s_grade in ("大数据2019-03","大数据2019-04");
两种方式的结果都是
3.4、IS NULL和IS NOT NULL
案例:班级不是大数据2019-03或者大数据2019-04的学生的学号和名字
SELECT
s_name,s_code
FROM `hel_student_info`
WHere
s_grade IS NOT NULL