I want to pull out duplicate records in a MySQL Database. This can be done with: SELECT address, count(id) a
It's easy to find duplicates with one field: SELECT name, COUNT(email) FROM users GROUP BY email HAVING