mybatis oracle和mysql like模糊查询写法

oracle:RESOURCE_NAME LIKE '%' || #{resourceName} || '%'
mysql:RESOURCE_NAME like concat(concat("%",#{paramMap.RESOURCE_NAME}),"%")