MyBatis foreach

# IN
<when test="id" != null and id != ''">
    AND (
        <foreach collection="ids" item="item" separator="," open="(" close=")">
            #{item}
        </foreach>
    )
</when>

# OR
<when test="id" != null and id != ''">
    AND (
        <foreach collection="ids" item="item" separator="OR">
            #{item}
        </foreach>
    )
</when>

# MyBatis update foreach 설정
jdbc:mysql://localhost:3306/test?allowMultiQueries=true