I am trying to update all the values in a column
SET column_name =
WHEN (label = 'AAA') THEN 'AA1'
WHEN (label = 'CCD') THEN 'C01'
WHEN (label = 'EGE') THEN 'FEF'
Only the labels that are mentioned in the case statement should be updated the rest should remain as it is.
Is CASE statement the only way or is there a better and easy method.
Thanks for the help.