Mybatis中oracle、mysql、db2、sql server的like模糊查詢

標籤：sql server   oracle   mybatis   mysql   db2   

<!-- 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><!-- 或者 --><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>

Mybatis中oracle、mysql、db2、sql server的like模糊查詢