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 vote268 views1 answer
Use where instead of join
SQL
1 vote294 views1 answer
T-SQL / AZURE Reseed
SQL
2 votes288 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote272 views1 answer
Sequelize postgresql schema
SQL
-1 vote270 views1 answer
Mysql #1064 error
SQL
0 vote260 views1 answer
List MySQL Table and Index Size
SQL
0 vote258 views1 answer
MySql count occurences more than"
SQL
0 vote270 views2 answers
Sql drop view if exists
SQL
0 vote267 views1 answer
This week mysql
SQL
2 votes310 views2 answers
Mysql compare datetime to another datetime
SQL