How to update Unique Key Column?

[Sathiya Moorthy]

Hi All,

I have Unique key column for `Mobile`. I am getting the Duplicate key entry Error.
Infact, i am not going to enter the duplicate value into the unique column, but i entered the same value in update query.

For ex:
if Table looks like

Username | Mobile(UniqueKey)
abc | 123
bbc | 456

if I am going to execute the following query means, i will get an error like 'Duplicate key '123' for `Mobile`

Update table1 set `username`='TEST'
MOBILE = '123'
WHERE `USERNAME`='abc'

PLEASE ANYONE CLARIFY REGARDING THIS ISSUE

THANKS IN ADVANCE.
SATHIYAMOORTHY