-- ==========================模糊查询=====================
-- 查询姓刘的同学 like结合 %(代表0到任意字符) _(代表一个字符)
SELECT studentno,`studentname` FROM `student`
WHERE studentname LIKE '王%'
-- 查询姓李的同学,名字后面只有一个字的
SELECT studentno,`studentname` FROM `student`
WHERE studentname LIKE '李_'
-- 查询姓李的同学,名字后面两个字的
SELECT studentno,`studentname` FROM `student`
WHERE studentname LIKE '李__'
-- 查询姓李的同学,名字当中有‘八’的
SELECT studentno,`studentname` FROM `student`
WHERE studentname LIKE '%八%'
-- ==========================IN的查询条件=====================
-- 查询1001,1002,1003学员信息
SELECT studentno,`studentname` FROM `student`
WHERE studentno IN (1001,1002,1003)
-- 查询广东的学生
SELECT studentno,`studentname` FROM `student`
WHERE `address` IN ('广东深圳')