Remove duplicate entries / rows a mySQL database table

ALTER IGNORE TABLE yourtablewithdups ADD UNIQUE INDEX dupidx (field_1 [, field_2x]);
ALTER TABLE yourtablewithdups DROP INDEX dupidx