Sql case sttement with set

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 vote236 views1 answer
Mysql timeout 30 seconds
SQL
3 votes276 views2 answers
Postgresql select all column names
SQL
19 votes274 views4 answers
Rename database in sql
SQL
0 vote284 views1 answer
Sql last 3 rows
SQL
0 vote268 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote267 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
3 votes272 views1 answer
Select sequence oracle
SQL
8 votes231 views1 answer
Similarities between ddl and dml
SQL
1 vote248 views1 answer
Sql myisam vs innodb
SQL
0 vote268 views1 answer
Alter table fulltext
SQL