check duplication of a column value in MySQL

To find  the duplicate username in users table in MySQL:
 SELECT username, COUNT(*) c
FROM `users`
GROUP BY username
HAVING c> 1

 To get more detail information
SELECT firstname, lastname, username
FROM `users`
WHERE username IN
 (
 SELECT username
FROM `users`
GROUP BY username
HAVING COUNT(*) > 1
)