mybatis:查询数组字段的SQL写法 废话不说,直接上代码:<if test="type != null and type != ''"> AND a.`type` IN <foreach item="typeArray" collection="type.split(',')" open="(" separator="," close=")"> #{t SQL知识点 2023-04-03 68 点赞 1 评论 103 浏览