mysql - remove duplicate records

CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1 GROUP BY [COLUMN TO remove duplicates BY];

DROP TABLE old_table;

RENAME TABLE new_table TO old_table;