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

2 votes211 views1 answer
How to make insert script from table in SQL server
SQL
4 votes193 views3 answers
Mysql update with join
SQL
0 vote210 views3 answers
Query string not ending with with vowels
SQL
2 votes287 views1 answer
Mariadb json select
SQL
0 vote223 views1 answer
How to define a non primary composite key in sql
SQL
0 vote201 views1 answer
Add column to table with default value plsql
SQL
0 vote214 views1 answer
Xampp mysql version
SQL
1 vote191 views1 answer
Media sql
SQL
0 vote229 views1 answer
Mysql best varchar length size
SQL
0 vote197 views1 answer
How to make case insensitive in sql
SQL