mybatis 多个字段模糊匹配

<!--获取归档人-->
<!--@author -->
<!--@since 2018-07-17-->
<select id="getArchiveInfo" parameterType="string" resultMap="BaseMap">
   SELECT DISTINCT archive_id AS id ,archive_name AS  name
   FROM t_fi_invoice_ocr
   WHERE is_deleted = 0
   <if test="archiveInfo != null and archiveInfo != ''">
      AND (archive_id like concat('%',#{archiveInfo},'%') OR archive_name  like concat('%',#{archiveInfo},'%'))
   </if>
</select>