select * from user a where exists
(select 1 from user where a.username=fmail or username=a.fmail)
or
(select 1 from user where a.hometel=tel or hometel=a.tel)
(select 1 from user where a.username=fmail or username=a.fmail)
or
(select 1 from user where a.hometel=tel or hometel=a.tel)
(select 1 from user where a.username=fmail or username=a.fmail)
or
(select 1 from user where a.hometel=ftel or hometel=a.ftel)
from user
where (username,fmail,mmail) in (select username,fmail,mmail from user group by username,fmail,mmail having count(*)>1)
前几天刚写的文章