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 vote150 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
6 votes174 views2 answers
Return columns from table sql
SQL
0 vote155 views1 answer
Sql ignore
SQL
1 vote144 views1 answer
Psql autocomplete for mac brew install
SQL
5 votes153 views3 answers
Oracle list columns in schema
SQL
0 vote134 views3 answers
Joins and views sql
SQL
5 votes144 views5 answers
Find max number in sql
SQL
0 vote138 views1 answer
Mysql add comment to column
SQL
0 vote174 views1 answer
Alter owner in PostgreSQL
SQL
6 votes138 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL