remove row with same value mysql code example

Example 1: mysql delete row

DELETE FROM products WHERE product_id=1;

Example 2: how to delete all duplicate items in mysql

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