Sql case update

UPDATE dbo.TestStudents  
SET     LASTNAME =  CASE  
                        WHEN LASTNAME = 'AAA' THEN 'BBB' 
                        WHEN LASTNAME = 'CCC' THEN 'DDD' 
                        WHEN LASTNAME = 'EEE' THEN 'FFF' 
                        ELSE LASTNAME
                    END 
WHERE   LASTNAME IN ('AAA', 'CCC', 'EEE')

Source: stackoverflow.com

Similar codes

6 votes202 views1 answer
Postgresql add enum value
SQL
7 votes231 views2 answers
Phpmyadmin change password
SQL
0 vote198 views1 answer
Mysqlimport
SQL
2 votes209 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
12 votes220 views2 answers
Insert multiple rows from another table sql
SQL
-1 vote211 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote197 views1 answer
How to select only id where is not in column mysql
SQL
0 vote196 views1 answer
Json_remove mysql
SQL
0 vote220 views1 answer
Postgres list all stored procedures query
SQL
16 votes214 views1 answer
Mysql smallint range
SQL