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

0 vote187 views1 answer
Tsql cmd exec script from file
SQL
4 votes183 views2 answers
How to count items with same name in sql
SQL
0 vote174 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote185 views1 answer
Mysql uuid
SQL
2 votes174 views1 answer
Create table with primary key
SQL
4 votes196 views1 answer
Adding data to table in sql python
SQL
0 vote147 views1 answer
Print sum of values sql
SQL
1 vote228 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote198 views1 answer
Oracle running queries sql
SQL
0 vote263 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL