Delete duplicate records in MySQL

Delete duplicate users by Username with this query..

DELETE a FROM tbl_user a INNER JOIN tbl_user b ON a.user_name = b.user_name WHERE a.id <> b.id