Oracle:
// 两种方式
select * from user where name like concat('%',#{name},'%')
select * from user name like '%'||#{name}||'%'
Mysql:
select * from user where name like concat('%',#{name},'%')
// 两种方式
select * from user where name like concat('%',#{name},'%')
select * from user name like '%'||#{name}||'%'
select * from user where name like concat('%',#{name},'%')