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 vote272 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
1 vote297 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote278 views1 answer
Psql get table data types
SQL
25 votes331 views5 answers
Mysql replace text
SQL
-1 vote253 views1 answer
Sql getdate date only
SQL
0 vote279 views1 answer
Get last three characters in mysql column
SQL
0 vote257 views1 answer
Mysql find db contarint
SQL
2 votes327 views3 answers
Mysql unix timestamp to date
SQL
1 vote262 views2 answers
Change table name phpmyadmin
SQL
0 vote251 views1 answer
Sql query for getting data with join and count
SQL