在查询条件后面反复添加OR id LIKE CONCAT(’%’,’**’,’%’)
<if test="Id != null and Id != '' "> AND
<foreach item="IdStr" collection="Id.split(',')" open="(" separator="OR" close=")">
id LIKE CONCAT('%', #{IdStr}, '%')
</foreach>
</if>
sql语句:
select * from order WHERE deal_result IS NULL and ( id LIKE CONCAT('%', ?, '%') OR id LIKE CONCAT('%', ?, '%') );