Mybatis in 逗号分隔字符串

<update id="softDel" parameterType="String">
SELECT *
FROM study

WHERE id in
<foreach item="item" index="index" collection="ids.split(',')"  open="(" separator="," close=")">
  #{item}
</foreach>
</update>

String ids = “1,2,3”,如ids作为参数。