- <!-- 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模糊查询
最新推荐文章于 2023-09-28 17:34:41 发布