Selecting and displaying duplicates in a MySQL DB:

SELECT *
FROM table
WHERE column IN (
 SELECT column
 FROM table
 GROUP BY column
 HAVING (COUNT(column) > 1)
)