数据库字段是逗号分隔字符串，传入值是字符串list，判断二者是否有交集

木简韵

于 2017-03-18 11:31:23 发布

阅读量1.2k

点赞数 1

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

本文链接：https://blog.youkuaiyun.com/hmh123123hmh/article/details/63252318

版权

技术专栏收录该内容

20 篇文章

订阅专栏

<select id="queryByCondTotal" resultType="int" parameterType="java.util.Map" >
  select  count(id)
  from notice_task
  <where>
    <if test="bldgIds!=null and bldgIds.size()>0">
      <foreach item="item" index="index" collection="bldgIds"
               open="(" separator=" OR " close=")">
        find_in_set(#{item}, bldgId)
      </foreach>
    </if>
    <if test="bldgIds==null or bldgIds.size()==0">
      and 0=1
    </if>
    <if test="bldgId!=null and bldgId!='' " >
      and find_in_set(#{bldgId,jdbcType=VARCHAR}, bldgId)
    </if>
    <if test="selType!=null" >
      and selType = #{selType,jdbcType=INTEGER}
    </if>
    <if test="keyWord!=null and keyWord!='' " >
      and upper(title) LIKE CONCAT('%',#{keyWord,jdbcType=VARCHAR},'%')
    </if>

  </where>
</select>