都没测试过。。。。慎用
MySql:
select * from t_user where name like concat('%', #{name}, '%')
Orcle:
select * from t_user where name like '%' || #{name} || '%'
sqlServer
select * from t_user where name like '%' + #{name} + '%'
发现预编译sql语句:
select * from person where name like "%"#{name}"%"(感觉不靠谱)