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 vote251 views3 answers
Classement rang mysql 7
SQL
0 vote201 views1 answer
Sql find table by name
SQL
1 vote191 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote194 views1 answer
Not between mysql
SQL
0 vote270 views1 answer
<sql:datasource var="Snapsho"
SQL
8 votes179 views1 answer
Oracle add month
SQL
3 votes294 views3 answers
Mysql get table size
SQL
0 vote211 views1 answer
Sql decode
SQL
1 vote203 views2 answers
Sql multiline comment
SQL
0 vote197 views2 answers
How covert into int in maria db
SQL