mybatis 根据字符串按逗号拼接的字段，进行条件查询

两种用法，推荐第一种：

1.利用mybatis的split方法，将包含逗号的字符串拆分成list

	<select id="queryNameFromYourTable" resultType="java.lang.String">
        SELECT name FROM your_table
        <where>
            <if test="ids != null and ids != ''">
                AND id IN
                <foreach collection="ids.split(',')" item="item" open="(" close=")" separator=",">
                    #{item}
                </foreach>
            </if>
        </where>
    </select>

2.使用模糊查询

	<select id="queryNameFromYourTable" resultType="java.lang.String">
        SELECT name FROM your_table WHERE ids LIKE CONCAT('%',#{id},'%')
    </select>

记住用ids like id，别写反了

---