Query to select duplicate fields

[TheMilkCarton]

Originally Posted by Eikinskjaldi

You could use group_concat



select username, group_concat(email), count(*) from user group by username having count(*) > 1

Thanks so much. I had to switch it up a bit, but thanks for the right direction.

It ended up looking like:

[sql]SELECT email, group_concat( username ) , COUNT( email )
FROM user
GROUP BY email
HAVING (COUNT( email ) >1)[/sql]