Change column name and Make a unique column so we get nodupes.

mysql> alter table [table name] change [old column name] [new column name] varchar (50);

mysql> alter table [table name] add unique ([column name]);