<if test="plantNameList.size > 0">
and (m.plant_name in
<foreach collection="plantNameList" index="index" item="plantName" open="(" separator="," close=")">
#{plantName}
</foreach>
or m.fourth_name in
<foreach collection="plantNameList" index="index" item="plantName" open="(" separator="," close=")">
#{plantName}
</foreach>)
</if>
想看sql语句可以到我的主页查找👇
https://blog.csdn.net/chenkunNB/article/details/123498599?spm=1001.2014.3001.5501