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

4 votes203 views2 answers
Insert current date in mysql
SQL
0 vote175 views1 answer
Power query datetime to date
SQL
0 vote159 views1 answer
List MySQL Table and Index Size
SQL
0 vote200 views1 answer
Virtuoso sql query tutorial
SQL
0 vote175 views2 answers
Sql trigger difference between for and after
SQL
5 votes206 views2 answers
Postgresql insert select
SQL
8 votes158 views3 answers
Duplicate entry
SQL
0 vote180 views1 answer
Sql check if column exists
SQL
23 votes176 views4 answers
Sql server substring
SQL
4 votes218 views1 answer
Mysql query first character
SQL