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 vote301 views1 answer
Selecting all columns from table sql database
SQL
5 votes308 views2 answers
Create table mysql example auto_increment
SQL
0 vote282 views1 answer
Sql query to select records entered in last 24 hours
SQL
-1 vote316 views5 answers
Not in sql
SQL
5 votes315 views4 answers
Restart the psql server windows
SQL
6 votes283 views1 answer
Update left join mysql
SQL
1 vote310 views1 answer
Table information in sql server
SQL
1 vote282 views1 answer
Oracle lock user
SQL
13 votes301 views4 answers
Command line mysql import
SQL
0 vote290 views1 answer
Postgres data location
SQL