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

0 vote138 views1 answer
Mysql two joins
SQL
0 vote141 views1 answer
Plpgsql raise notice
SQL
4 votes150 views1 answer
Sql quote in string
SQL
2 votes151 views1 answer
Sql skip the first row
SQL
18 votes136 views2 answers
Sql inner join
SQL
3 votes134 views2 answers
Update Query in SQL Server
SQL
4 votes144 views3 answers
Count with where
SQL
8 votes133 views4 answers
Mysql update one table from another table multiple columns
SQL
1 vote161 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote129 views1 answer
Oracle search columns in schema
SQL