Replacing Duplicated MySQL values

[GUIR]

Hi,

There is a MySQL table having duplicates(X2 - not other multiples)
,

I need to have a query which will search for duplicated values, keep first value unchanged, [u]second value which is being dupilcated should be replaced by a given text.

This has to be done for all duplicates' second entry.

Is there a simpler way to achieve this.

Thanks and Best Regards

[chazzy]

what makes them duplicate? what are the columns in the table?