22,300
社区成员




select * from user where email like '%'+username+'%'
select * from user
where charindex(username,email)>0
SELECT *
FROM USER A
WHERE EXISTS(SELECT *
FROM USER B
WHERE B.EMAIL LIKE '%' + A.USERNAME + '%')