mybatis update标签，使用foreach时，where的用法

<update id="updateConfirmStatus" parameterType="java.util.List">
    UPDATE ay_product_plan
    SET aypp_confirm = 2
    <where>
      aypp_aywoid in
      <foreach collection="list" item="item" separator="," open="(" close=")">
        #{item,jdbcType=INTEGER}
      </foreach>
      </where>
  </update>

当使用< where>时，会出现Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘}’ at line 6

<update id="updateConfirmStatus" parameterType="java.util.List">
    UPDATE ay_product_plan
    SET aypp_confirm = 2
    where
      aypp_aywoid in
      <foreach collection="list" item="item" separator="," open="(" close=")">
        #{item,jdbcType=INTEGER}
      </foreach>
  </update>

而直接使用where时，就没有问题，在此标记一下