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

1 vote130 views1 answer
Mysql backup skip table
SQL
0 vote124 views1 answer
Oracle current timestamp
SQL
-1 vote119 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
-1 vote133 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote145 views1 answer
Pgadmin check database
SQL
2 votes119 views2 answers
Select multiple tables mysql
SQL
8 votes92 views1 answer
Oracle current date plus 1 month
SQL
1 vote122 views1 answer
Sqlite check if row exists
SQL
0 vote122 views1 answer
Sqlcmd no headers
SQL
6 votes157 views1 answer
How to get the size of the database in postgresql
SQL