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 vote149 views1 answer
Mql5 list all available symbols
SQL
7 votes168 views1 answer
Connect mysql docker
SQL
8 votes196 views1 answer
Oracle search text in all packages
SQL
1 vote154 views1 answer
Foreign key constraint in ms sql
SQL
0 vote173 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote160 views1 answer
Show function mysql
SQL
3 votes164 views1 answer
Show index table
SQL
0 vote168 views1 answer
Mysql shell set time_zone
SQL
0 vote178 views1 answer
Sqlcl format
SQL
0 vote194 views1 answer
Sql sum if
SQL