Duplicate record

[#1]

I have some duplicate records in my table "sys_user". How to make one record as inactive based on some field ( like email because in one record email field is empty) & to add prefix like old-username .....

[sherman_1206]

Thanks for the clarifications!