-- like %0到任意个字符 一个下划线_代表一个字符
SELECT * FROM student WHERE NAME LIKE '孙%'
SELECT * FROM student WHERE NAME LIKE '孙_'
SELECT * FROM student WHERE NAME LIKE '孙__'
SELECT * FROM student WHERE NAME LIKE '%水%'
-- in
SELECT * FROM STUDENT WHERE SID IN(7,8,9)
SELECT * FROM STUDENT WHERE sadd IN('菏泽')
-- NULL
SELECT * FROM STUDENT WHERE GRADE IS NULL
SELECT * FROM STUDENT WHERE GRADE IS NOT NULL