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 vote152 views1 answer
T-sql update table variale
SQL
25 votes167 views3 answers
Mysql command show tables
SQL
0 vote142 views1 answer
Psql attribute cannot login
SQL
0 vote159 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote160 views1 answer
Pagination with row_number
SQL
0 vote157 views1 answer
Drop view in mysql
SQL
0 vote158 views1 answer
Sql include rows with 0 values
SQL
1 vote151 views2 answers
Pad zero sql server
SQL
3 votes168 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote301 views1 answer
Multiple row join
SQL