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

0 vote211 views1 answer
Describe in sqlite3
SQL
0 vote255 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
5 votes241 views2 answers
Create table mysql example auto_increment
SQL
0 vote225 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote208 views1 answer
Postgresql inheritance
SQL
0 vote253 views1 answer
Original Query
SQL
0 vote232 views1 answer
How to add unique key constraint in mysql
SQL
6 votes209 views2 answers
Mysql convert timestamp to date
SQL
0 vote227 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote297 views1 answer
Mysql readable output
SQL