how to delete all duplicate items in mysql
snippet in sql

how to delete all duplicate items in mysql

user2805

DELETE FROM FriendsData WHERE fID 
       NOT IN ( SELECT fID FROM FriendsData 
                   GROUP BY UserID, FriendsUserID, IsSpecial, CreatedBy)