mybatis 批量in 多个字段写法，可以参考如下写法

select distinct id, post_name from user a where
(a.year,a.month,a.status) in  (('2021','1',1),('2021','1',1),('2021','3',1)) order by id asc 

 

select * from user where (user_id,type) in ((568,6),(569,6),(600,8));

　　

改成mybatis

select distinct
　　　　a.id as post_id, a.post_name as post_name
from user_his a where
(a.year,a.month,a.status) in
<foreach collection="yearMonth" item="item" open="(" close=")" separator=",">
    (#{item.year},#{item.month},'1')
</foreach>
order by id asc