How to find all the duplicates in my MySQL table

SELECT <column name>, COUNT( <column name> ) AS numOcc
FROM <table>
GROUP BY <column name>
HAVING (
COUNT( <column name>) >1
)

This is an example of where you have duplicates in one column only.