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

5 votes207 views1 answer
Oracle list days between two dates
SQL
5 votes204 views3 answers
String concatenation sql server
SQL
2 votes221 views1 answer
Postgresql create schema in specific database
SQL
0 vote194 views1 answer
Check if table exists oracle
SQL
0 vote219 views1 answer
Proc sql not in working
SQL
0 vote196 views1 answer
What does the -p flag do in mysql cli
SQL
6 votes223 views3 answers
Oracle all dates between two dates
SQL
-2 votes229 views2 answers
Add auto_increment column to existing table mysql
SQL
1 vote187 views1 answer
Sqlite check if row exists
SQL
0 vote181 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL