mybatis 遍历list拼接 or查询

<if test="myList != null and myList.size() >0">

    <foreach collection="myList" index="index" item="item" open="and (" separator=" or " close=")">

        name like concat("%",#{item,jdbcType=VARCHAR},";%")
    </foreach>
</if>