UPDATE vn.accountDetailType SET code = CASE description WHEN 'IBAN' THEN 'iban' WHEN 'SWIFT' THEN 'swift' WHEN 'Referencia Remesas' THEN 'remRef' WHEN 'Referencia Transferencias' THEN 'trnRef' WHEN 'Referencia Nominas' THEN 'payRef' WHEN 'ABA' THEN 'aba' END;