Sql case update

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 votes174 views3 answers
Application.properties spring boot mysql
SQL
1 vote171 views1 answer
Import database from a file using mysql commandline
SQL
15 votes194 views5 answers
Show tables in oracle
SQL
4 votes223 views1 answer
Sql delete multiple conditions
SQL
4 votes224 views1 answer
How to drop a database in sql server when it is in use
SQL
1 vote165 views1 answer
Sql group by error
SQL
0 vote171 views1 answer
Char varchar nvarchar sql
SQL
0 vote198 views1 answer
What is delimiter in mysql
SQL
15 votes278 views5 answers
Select all tables sql
SQL
9 votes187 views1 answer
Sql server get utc date
SQL