query to remove duplicate mysql

Easiest way to do this is to add a UNIQUE index on the column. When you write the ALTER statement,