Mybatis-foreach字符串分割

案例：

改造前：

select * from wb_main_project where id in ('1','2')

改造后：

​select * from wb_main_project where id in 
<foreach collection="projectId.split(',')" item="item" index="index" 
open="(" separator="," close=")"> #{item}
</foreach>