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 vote344 views1 answer
Mysql use password error
SQL
1 vote347 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote349 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
10 votes334 views2 answers
Forgot my mysql password mac
SQL
2 votes348 views1 answer
Compare date in sql
SQL
0 vote353 views1 answer
VSCode SQL Server Connection error
SQL
2 votes376 views1 answer
Oracle trace file
SQL
0 vote353 views1 answer
Const pool = mysql.createpool()
SQL
1 vote365 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
10 votes364 views3 answers
Join multiple tables sql
SQL