<!--获取归档人--> <!--@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>
mybatis 多个字段模糊匹配
最新推荐文章于 2024-07-12 15:53:15 发布