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

来源：互联网发布：淘宝改类目影响排名吗编辑：程序博客网时间：2024/05/16 19:08

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

0 0