From db93e8671fe9192dcd3ec5b364b65c672073b56e Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Fri, 04 Jun 2021 11:39:19 +0800
Subject: [PATCH] 20210604
---
src/main/resources/mapper/modules/MemberMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/modules/MemberMapper.xml b/src/main/resources/mapper/modules/MemberMapper.xml
index dd75952..532fec9 100644
--- a/src/main/resources/mapper/modules/MemberMapper.xml
+++ b/src/main/resources/mapper/modules/MemberMapper.xml
@@ -1986,7 +1986,7 @@
and #{record.endTime} >= m.create_time
</if>
<if test="record.account!=null and record.account!=''">
- and (m.phone = #{record.account} or m.email = #{record.account} or m.invite_id=#{record.account})
+ and (m.phone like concat('%', #{record.account},'%') or m.email like concat('%', #{record.account},'%') or m.invite_id like concat('%', #{record.account},'%'))
</if>
<if test="record.accountStatus!=null">
and m.account_status = #{record.accountStatus}
--
Gitblit v1.9.1