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

27 votes239 views6 answers
Set password mysql
SQL
0 vote237 views1 answer
Get from database the most recent data limit by 5
SQL
18 votes218 views2 answers
Sql comments
SQL
0 vote269 views1 answer
Modifier une valeur sql
SQL
1 vote234 views1 answer
Sql server get users
SQL
4 votes231 views3 answers
Mysql modify foreign key
SQL
1 vote234 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote245 views1 answer
Sp in sql server
SQL
0 vote346 views1 answer
Postgresql powershell query
SQL
1 vote239 views1 answer
Mysql view current queries
SQL