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

1 vote197 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote273 views1 answer
Dynamic where clause in sql server stored procedure
SQL
19 votes326 views5 answers
Mysql between date range
SQL
0 vote227 views1 answer
Sql requete number pair
SQL
1 vote211 views2 answers
T sql get foreign key
SQL
0 vote232 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
5 votes209 views1 answer
Sql check if date is between 2 dates
SQL
0 vote238 views1 answer
Virtuoso sql query tutorial
SQL
16 votes199 views3 answers
Delete row psql
SQL
0 vote228 views1 answer
Sqlite löschen einer tabelle
SQL