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 vote382 views1 answer
Geopoint from json mysql function
SQL
0 vote428 views1 answer
Mssql last day of month
SQL
2 votes371 views1 answer
Postgresql update sequence next value
SQL
0 vote351 views1 answer
Login phpmyadmin without password
SQL
0 vote434 views1 answer
Python get backup of sql
SQL
0 vote359 views1 answer
Oracle query archivemode
SQL
0 vote366 views1 answer
Sintaxis SELECT sql
SQL
20 votes343 views2 answers
Counting in sql
SQL
0 vote369 views1 answer
Automated psql csv export script on windows
SQL
0 vote403 views1 answer
Change date format in oracle query
SQL