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 vote210 views1 answer
Insert ip address in mysql
SQL
4 votes199 views2 answers
Oracle unlock user
SQL
0 vote202 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote180 views1 answer
Postgresql array to rows
SQL
8 votes203 views2 answers
Sqlsrv default port
SQL
19 votes204 views6 answers
Sql drop table if exists
SQL
6 votes192 views1 answer
Wordpress change user password sql
SQL
0 vote196 views1 answer
Get number of tables in database sql
SQL
0 vote222 views1 answer
Add super privilege mysql
SQL
0 vote204 views1 answer
Mysql timediff
SQL