How to search for duplicate records or rows in MySQL

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.