Sql case sttement with set

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 vote331 views1 answer
Dynamic where clause in sql server stored procedure
SQL
12 votes325 views1 answer
Run mysql instance in docker
SQL
13 votes488 views4 answers
Sql joining 3 tables
SQL
1 vote306 views1 answer
Sql group by sum with condition
SQL
1 vote278 views1 answer
Scaffold mysql database
SQL
2 votes296 views1 answer
Sql update from different table
SQL
3 votes377 views1 answer
Oracle nextval insert
SQL
2 votes307 views2 answers
Storing timezones in postgres
SQL
4 votes332 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
3 votes294 views1 answer
Select without null values sql
SQL