ORACLE

select * from tableName where name like  CONCAT(CONCAT('%', #{name}),'%');

 

MYSQL

select * from tableName where name like  CONCAT('%',#{name},'%');