Sql case sttement with set

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

2 votes134 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote115 views2 answers
Insert into
SQL
0 vote148 views1 answer
Time in sql server
SQL
2 votes117 views2 answers
How to create an empty table from an existing table
SQL
0 vote118 views1 answer
Get first name and last name from full name string in SQL
SQL
1 vote167 views1 answer
Postgres set sequence value to max id
SQL
0 vote146 views1 answer
Postgresql port 5432 not open
SQL
12 votes136 views6 answers
Between in sql
SQL
2 votes121 views2 answers
Mysql on duplicate key ignore
SQL
1 vote112 views1 answer
What is int in mysql
SQL