mybits中IN和LIKE查询

最新推荐文章于 2024-09-15 11:26:48 发布

qq_37567381

最新推荐文章于 2024-09-15 11:26:48 发布

阅读量175

点赞数

分类专栏：数据库文章标签： Oracle

本文链接：https://blog.csdn.net/qq_37567381/article/details/84541515

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

<select useCache="false" id="getConcernPageByUserEname" resultType="com.zbxsoft.chtrans.entity.ChConcern" parameterType="java.util.Map">
SELECT * FROM
(select co.*,rownum as row_num from (
SELECT * FROM CH_CONCERN h where 1=1
<if test="usercname !=null and usercname != ''">
AND h.USERCNAME like concat(concat('%', #{usercname}),'%')
</if>
<if test="userenames !=null and userenames != ''">
AND h.USERENAME in
<foreach item="item" index="index" collection="userenames"
open="(" separator="," close=")">
#{item}
</foreach>
</if>
<if test="userenames == ''">
AND 1=-1
</if>
order by h.creattime desc ) co) tt
WHERE tt.row_num BETWEEN #{offset} AND #{limit}

</select>