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 vote222 views1 answer
Mssql unique key accept nulls
SQL
0 vote135 views1 answer
Mysql match in serialized data
SQL
2 votes139 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote141 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote136 views1 answer
Pl/sql loop example
SQL
0 vote142 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
16 votes148 views2 answers
Oracle ddl
SQL
0 vote135 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote141 views4 answers
Postgresql between month
SQL
0 vote155 views2 answers
Reseed sql identity
SQL