%:任意个任意字符
_:一个任意字符
-- 查询student表中name以S开头的学生
select * from student where name like 'S%';
-- 查询student表中name的第二个字母是A的学生
select * from student where name like '_A%';
-- 查询student表中name包含E的学生
select * from student where name like '%E%';
-- 查询student表中name长度为3的学生
select * from student where name like '___';