① _ :匹配一个特定的字符;
例如:查找student表中姓张的,且名字为两个字的同学
select * from student where name like '张_';
例如:查找student表中名字为三个个字,且结尾为林的同学
select * from student where name like '_ _林';
② %:匹配0个或任意个字符;
例如:查找student表中姓张的同学
select * from student where name like '张%';
例如:查找英文名字中带有A的同学
select * from student where name like '%a%'; (mysql不区分大小写)