Delete duplicate rows in mysql table

It is Possible to DELETE duplicate rows in MYSQL table based on Particular Field (Coloumn)

the SQL Query is

ALTER IGNORE TABLE table_name ADD UNIQUE INDEX(coloumn_name);