Oracle:
select * from tb_user where name like concat('%',#{name},'%');
或者
select * from tb_user where name like '%'||#{name}||'%';
Mysql:
select * from tb_user where name like concat('%',#{name},'%')
Sql Server
select * from tb_user where name like '%'+#{name}+'%';
通用
select * from tb_user where 1=1
<if test="name !=null and name !=''">
<bind name="pattern" value="'%'+parmater.name+'%'" />
and name like #{pattern}
</if>