From 1991cda18d5675f754e3960b6de95a0089bf7440 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 20 三月 2023 16:02:03 +0800
Subject: [PATCH] 1

---
 src/main/java/com/lf/server/mapper/all/BasicMapper.java |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/lf/server/mapper/all/BasicMapper.java b/src/main/java/com/lf/server/mapper/all/BasicMapper.java
index 93c9dac..61ac03c 100644
--- a/src/main/java/com/lf/server/mapper/all/BasicMapper.java
+++ b/src/main/java/com/lf/server/mapper/all/BasicMapper.java
@@ -20,7 +20,7 @@
      * @param value 鍊�
      * @return 缁撴灉鍒楄〃
      */
-    @Select("select ${field} from ${tab} where ${field} like #{value} order by ${field} limit 10")
+    @Select("select ${field} from ${tab} where upper(${field}) like #{value} order by ${field} limit 10")
     public List<String> selectFieldFuzzy(@Param("tab") String tab, @Param("field") String field, @Param("value") String value);
 
     /**

--
Gitblit v1.9.3