mybatis动态SQL

<!--Mybatis动态SQL中使用Like语句-->
select * from person where name  like "%"#{name}"%"<!--推荐使用-->
 
select * from person where name  like '%'||#{name}||'%'
 
select * from person where name  like '%${name}%'
原文地址:https://www.cnblogs.com/oyx305/p/5112860.html