mybatis likeクエリー%

--all
select * from user where name like '%${name}%'

--mysql,oracle,db2
select * from user where name like concat('%',#{name},'%') 

--oracle,db2
select * from user where name like '%'||#{name}||'%'

--SQL Server
select * from user where name like '%'+#{name}+'%'

--        ，    
select * from user where name like "%"#{name}"%"