From 9ff88ffb78565b09a038d31b804723e9756b3217 Mon Sep 17 00:00:00 2001
From: houruijun <411269194@kidgrow.com>
Date: Thu, 29 Oct 2020 10:25:18 +0800
Subject: [PATCH] 修改模糊查询医院，增加按照id排序
---
kidgrow-business/kidgrow-usercenter/kidgrow-usercenter-biz/src/main/resources/mapper/SysHospitalMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/kidgrow-business/kidgrow-usercenter/kidgrow-usercenter-biz/src/main/resources/mapper/SysHospitalMapper.xml b/kidgrow-business/kidgrow-usercenter/kidgrow-usercenter-biz/src/main/resources/mapper/SysHospitalMapper.xml
index 687de0e..6cf3fed 100644
--- a/kidgrow-business/kidgrow-usercenter/kidgrow-usercenter-biz/src/main/resources/mapper/SysHospitalMapper.xml
+++ b/kidgrow-business/kidgrow-usercenter/kidgrow-usercenter-biz/src/main/resources/mapper/SysHospitalMapper.xml
@@ -276,7 +276,7 @@
hospital_name
from sys_hospital
where is_del=0 and enabled=1 and hospital_name LIKE concat('%',#{hospitalName},'%')
- order by hospital_name desc
+ order by hospital_name desc,id desc
</select>
<select id="chartHospital" resultType="int" parameterType="int">
SELECT
--
Gitblit v1.8.0