mybatis 字段like查询
<if test="conditionName != null and conditionName != ''">
<bind name="_conditionName" value="'%' + conditionName + '%'"/>
and t.condition_name LIKE #{_conditionName}
</if>
或者
<if test="queryCondition != null and queryCondition != ''" >
AND (
person_idcard = #{queryCondition,jdbcType=VARCHAR}
or person_name like concat('%',concat(#{queryCondition},'%'))
)
</if>