(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 '%解放%'