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 vote278 views1 answer
Mysql utc timestamp
SQL
0 vote281 views1 answer
Mysql select field if condition
SQL
0 vote285 views1 answer
Top frequency in sql server
SQL
4 votes271 views2 answers
Mysql show indexes on table
SQL
0 vote270 views2 answers
Android sqlite tutorial for beginners
SQL
1 vote271 views1 answer
Oracle list data files
SQL
0 vote278 views1 answer
Not equal to blank in mysql
SQL
0 vote270 views1 answer
Use between operator in mysql
SQL
1 vote290 views1 answer
Vagrant mysql downgrade version
SQL
0 vote226 views1 answer
Mysql select top 2
SQL