Update Multiple Records in Same Column in SQL

vipin kumar

11y1.2kCode

This code snippet for how to update Multiple Records in Same Column.

update t1 set name=
case name
   when 'a' then 'b'
   when 'd' then 'g'
   when 'd' then 'g'
else
   name
end