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

来源：互联网发布：vmware 共享 linux 编辑：程序博客网时间：2024/04/30 04:14

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