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 vote117 views1 answer
Uncomment listen_address=localhost
SQL
11 votes119 views1 answer
Oracle view source
SQL
0 vote123 views1 answer
T sql check active deadlock
SQL
0 vote114 views1 answer
C# check if mysql query modified rows
SQL
7 votes125 views2 answers
Oracle sql drop index
SQL
0 vote119 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
6 votes111 views1 answer
Oracle trigger after logon on database
SQL
0 vote123 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
1 vote114 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
2 votes147 views1 answer
Search query in mysql
SQL