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 vote210 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote230 views2 answers
Oracle select
SQL
0 vote242 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote224 views1 answer
Mysql date only no time
SQL
0 vote248 views1 answer
Remove mysql from centos 7
SQL
0 vote187 views1 answer
Java spring boot connect to sql server
SQL
1 vote220 views1 answer
Convert rows to string sql server
SQL
2 votes221 views1 answer
Sqlite indexes
SQL
0 vote217 views1 answer
Joins vs includes
SQL
11 votes613 views4 answers
Reset identity column values in sql server
SQL