数据库之DQL条件查询

SELECT * FROM student WHERE student_grade<=80（>< = != >= <=）
SELECT * FROM student WHERE student_grade<=80 && student_age=30 或者 SELECT * FROM student WHERE student_grade<=80 and student_age=30（&& and，|| or，! not ）
SELECT * FROM student WHERE student_age LIKE ‘2%’ 匹配以2开头的
SELECT * FROM student WHERE student_age LIKE ‘%2%’ 匹配含有2的
SELECT * FROM student WHERE student_age LIKE ‘_2’ 匹配第二个字符以2开头的
SELECT * FROM student WHERE student_age BETWEEN 20 AND 30（between…and…）
SELECT * FROM student WHERE student_age IN(20,30,29) （in）