How can I remove the unique option from a column in MySQL?

I have a field in my db called "user" which is unique.

I开发者_StackOverflow would like to remove the "unique" option so I can have couple of users with the same nickname.

Which sql statement should I execute to perform this action ?

Thanks

DROP INDEX name_of_your_unique_index;

UNIQUE is an index, so just drop it.