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 vote129 views1 answer
Sql server create constraint
SQL
3 votes117 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
-2 votes115 views1 answer
Mysql see users and passwords
SQL
0 vote103 views1 answer
Json not contains mysql
SQL
0 vote132 views2 answers
Plpgsql
SQL
10 votes100 views3 answers
Sql limit results
SQL
31 votes113 views3 answers
Sql count(*)
SQL
0 vote99 views1 answer
Minus equivalent in my sql
SQL
17 votes114 views4 answers
Postgres list users
SQL
2 votes110 views1 answer
Alter table add column and foreign key mysql
SQL