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 vote120 views1 answer
Search starting with mysql
SQL
0 vote134 views1 answer
Mariadb disable foreign key checks
SQL
5 votes112 views1 answer
Oracle find foreign key dependencies
SQL
3 votes119 views2 answers
Sql paging query
SQL
1 vote123 views1 answer
How do you use sql in you company
SQL
0 vote123 views1 answer
Mysql foreach insert
SQL
0 vote111 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote108 views1 answer
Concat column value of same user in mysql
SQL
4 votes123 views3 answers
Sqlite show columns
SQL
2 votes129 views1 answer
Oracle find constraints referencing a table
SQL