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

来源：互联网发布：淘宝全屏首页怎么上传编辑：程序博客网时间：2024/05/17 03:13

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