With this query you can find if there are any duplicates found in a specified column. The query will return you the field and how many occurrences have been found. In the following example the field is named email, it was used to find duplicate mail addresses.
SELECT `email`, COUNT(`email`) AS `cnt`
GROUP BY `email`
HAVING `cnt` > 1
ORDER BY `cnt`