mybatis oracle和mysql like模糊查詢寫法

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