Mybatis 中 Oracle 和 MySQL 的 like 模糊查询语法

<!-- oracle -->
 <select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
     select * from t_user where user_name like CONCAT('%',#{search_name})
 </select> // concat 函数在oracle里面只能连接两个字符串。
 <!-- 或者 -->
 <select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
     select * from t_user where user_name like '%'||#{search_name}||'%' 
 </select><!-- mysql -->
 <select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
     select * from t_user where user_name like CONCAT('%',#{search_name},'%')
 </select>
     
 <!-- sql server -->
 <select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
     select * from t_user where user_name like '%'+#{search_name}+'%'
 </select><!-- db2 -->
 <select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
     select * from t_user where user_name like CONCAT('%',#{search_name},'%')  
 </select>
 <!-- 或者 -->
 <select id="searchUserBySearchName" parameterType="java.lang.String" resultType="com.urm.entity.User">
     select * from t_user where user_name like '%'||#{search_name}||'%' 
 </select>