SQL语句-查询条件模糊匹配若干字段

(SQL语句)查询条件模糊匹配若干字段

(SQL语句)查询条件模糊匹配若干字段

方法一

select* from [dbo].[t_Member] t 
left join t_Member_Company tc on tc.id = t.companyId 
left join t_Company_TakeOrderSet ts  on ts.companyid = tc.id  
where  (t.account+'' + t.mobile + '' + t.phone + '' + t.email + '' + t.codeNo + '' + ts.bucket + '' + tc.companyName+'') 
LIKE '%多样化%' AND t.isMain = 1 AND t.Deleted = 0

方法二（推荐方法 -附：原文）

select * from [dbo].[t_Member] t 
left join t_Member_Company tc on tc.id = t.companyId 
left join t_Company_TakeOrderSet ts  on ts.companyid = tc.id  where
CONCAT (CONVERT(varchar,t.account,21)
,CONVERT(varchar,t.mobile,21),
CONVERT(varchar,t.phone ,21),
CONVERT(varchar,t.email ,21),
CONVERT(varchar,t.codeNo ,21),
CONVERT(varchar,ts.bucket ,21),
CONVERT(varchar,tc.companyName ,21)) like '%解放%'