MySql 模糊查询 like %%
select * from t_user where name like cancat('%','$(name)','%')
SQL Server 模糊查询 like %%
select * from t_user where name like '%'+#{name}+'%'
Oracle 模糊查询 like %%
select * from t_user where name like '%'||#{name}||'%'
摘自:http://mxdba.iteye.com/blog/844748
http://blog.csdn.net/educast/article/details/50560792