Mysql中字符匹配

%(匹配多个字符);
select * from product where name like 'a%b';
_(匹配单个字符);
select * from product where name like 'a_b';
regexp 正则匹配;
select * from product where name regexp 'ab'