From ff31cd67a14d356213cda3ddae9ef205db927eae Mon Sep 17 00:00:00 2001 From: zhanghl <253316343@qq.com> Date: 星期四, 17 四月 2025 15:44:19 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/dev' into dev --- aps-modules/aps-core/src/main/resources/mapper/core/ApsPlantMapper.xml | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlantMapper.xml b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlantMapper.xml index 6af672a..0422ad4 100644 --- a/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlantMapper.xml +++ b/aps-modules/aps-core/src/main/resources/mapper/core/ApsPlantMapper.xml @@ -22,8 +22,8 @@ <select id="selectApsPlantList" parameterType="ApsPlant" resultMap="ApsPlantResult"> <include refid="selectApsPlantVo"/> <where> - <if test="plantName != null and plantName != ''"> and plant_name like concat('%', #{plantName}, '%')</if> - <if test="plantCode != null and plantCode != ''"> and plant_code like concat('%', #{plantCode}, '%')</if> + <if test="plantName != null and plantName != ''"> and plant_name like '%' || #{plantName} || '%'</if> + <if test="plantCode != null and plantCode != ''"> and plant_code like '%' || #{plantCode} || '%'</if> <if test="status != null and status != ''"> and status = #{status}</if> </where> </select> -- Gitblit v1.9.3