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

2 votes273 views1 answer
Postgresql update sequence next value
SQL
4 votes240 views1 answer
Update table from another table oracle
SQL
0 vote248 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote281 views1 answer
Sql: extract day text from datetime value
SQL
3 votes262 views2 answers
Tsql join multiple record in one string
SQL
2 votes214 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote283 views1 answer
Prisma transaction
SQL
0 vote231 views1 answer
Sql requete number pair
SQL
17 votes248 views4 answers
Set mysql Password
SQL
0 vote226 views2 answers
Influxdb delete measurement based on date
SQL