UBB.Developers Forums UBB.threads 7 Development How Do I? Duplicate emails

I have users in my database that have signed up twice, using two different usernames, but the same email address. Is there a query that I could run that would list all accounts with the same email addresses so that I could manually delete one? Thanks.

I think it would be something like this:

select t1.U_Number,t1.U_Username,t2.U_Number,t2.U_Username,t1.U_RegEmail
from w3t_Users as t1, w3t_Users as t2
where t1.U_RegEmail = t2.U_RegEmail
and t1.U_Number != t2.U_Number



I haven't tried the query but I think it will work.

Anyone else have a better way? I'm probably behind the times or need to read more... LoL

I was just trying to figure this out. I didn't know about the t1 and t2 stuff though. Thanks for learnin' me!

BTW - I believe your query works. I just tested it and it didn't return any errors. Of course, I don't allow duplicate emails, but I changed != to = and it returned everyone.