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 vote141 views1 answer
Foreign key type uniqu mysql
SQL
2 votes164 views1 answer
Sql string starts with
SQL
9 votes148 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote181 views4 answers
Rownum in sql
SQL
20 votes155 views4 answers
Reset auto increment in MySQL
SQL
0 vote155 views1 answer
Oracle show grants on table
SQL
2 votes146 views1 answer
Mysql create user with mysql_native_password
SQL
1 vote151 views1 answer
Mysql pretty date format
SQL
0 vote154 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote144 views1 answer
We are intrested to work with your organization
SQL