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

0 vote116 views1 answer
Save single sql query result boolean spring boot
SQL
2 votes151 views3 answers
Postgres json to string
SQL
0 vote140 views2 answers
Faster mysql imports
SQL
0 vote129 views1 answer
Uncomment listen_address=localhost
SQL
0 vote117 views1 answer
Change database name psql 8
SQL
0 vote189 views1 answer
Order by number of character in sql
SQL
0 vote123 views1 answer
Nth max in my sql
SQL
40 votes202 views4 answers
PostgreSQL add column
SQL
0 vote126 views1 answer
Java sql connection
SQL
1 vote143 views5 answers
Sql 2nd highest salary
SQL