SELECT * FROM customer WHERE company_id=#{companyId} <if test="condition != null and condition != ''"> AND CONCAT(IFNULL(cust_name,''), IFNULL(cust_short_name,''),IFNULL(cust_code,'')) LIKE CONCAT(CONCAT('%',#{condition},'%')) </if>
mybatis根据同一个条件的得多字段模糊匹配
最新推荐文章于 2024-07-15 14:40:31 发布