This Is the Best way to delete duplicate entries in MySQL
alter ignore table table_name add unique index(column_name);
For example your table_name.column_name has “some” duplicate entries the best way to do is to put unique index on the column_name that has duplicates
Is that simple.