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

1 vote343 views1 answer
Mysql batch insert
SQL
0 vote342 views1 answer
Oracle job schedules
SQL
1 vote338 views1 answer
Show table columns
SQL
1 vote324 views1 answer
Stored procedure return value
SQL
1 vote360 views1 answer
How to install mysql 8.0 windows service
SQL
1 vote378 views1 answer
Sql drop schema
SQL
18 votes353 views3 answers
Mysql current date
SQL
6 votes341 views2 answers
Mysql version check cmd
SQL
1 vote364 views3 answers
Sql server get week dates from week number
SQL
0 vote345 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL