mybatis xml中根据分隔符遍历字符传

如题：mybatis xml中根据分隔符遍历字符传

demo:

List<TableVo> getTablesByIds(@Param("ids") String ids);

  select *
        from table
        where is_deleted = 0
             and id in
    <foreach collection="ids.split(',')" item="id"
             index="index" open="(" close=")" separator=",">
      #{id}
    </foreach>

当然也可以先在java代码处理成List

String ids = "1,2,3";
Splitter splitter = Splitter.on(",").trimResults();
List<Integer> ids = splitter.splitToList(ids)