Mybatis sql使用方法

--like 

select * from user where name like CONCAT('%',CONCAT(#{names,jdbcType=VARCHAR},'%' ))

-in 传集合

<select id="name" resultType="xxxxx">
select * from user where ID in
<foreach collection="list" item="item" open="(" separator="," close=")">
#{item,jdbcType=VARCHAR}
</foreach>
</select>