UPDATE table_name SET field_name = case field_name2 when 'value' then 'change_to' when 'value2' then 'change_to2' end