Remove Duplicate Entries from DB w/ Unique ID that is NOT Primary Key - Keep one of course!
If more than, say, half the table needs to be removed, it is faster (etc) to

CREATE TABLE new LIKE real;
ADD PRIMARY KEY (...);   -- or UNIQUE
INSERT INTO new
    SELECT DISTINCT ... FROM real;
RENAME TABLE real TO old,
             new TO real;
DROP TABLE old;