参数:clasifyId=”aa,bb“
sql:where 1=1 and (info.column1 like '%aa%' or info.column2='aa' or info.column1 like '%bb%' or info.column2='bb')
xml:
where 1=1
< if test="classifyId!=null and classifyId!=''">
and (
<foreach collecion="classifyId.split(',') item="item" index="index" separator="or">
<trim prefixOverrides="AND|OR" suffixOverrides="AND|OR">
or info.column1 like concat('%',#{item},'%') or info.column2 = #{item}
</trim>
</foreach>
)
</if>