Mybatis使用like，Mysql和oracle占位符写法

ORACLE

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

MYSQL

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