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 vote151 views1 answer
Trigger stock phpmyadmin output message
SQL
2 votes138 views2 answers
Mysql user access to database
SQL
0 vote149 views1 answer
Laravel eloquent get generated sql
SQL
0 vote162 views1 answer
Select new table sql
SQL
1 vote142 views1 answer
Postgresql reset serial counter after deleting content
SQL
1 vote138 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
3 votes142 views1 answer
Only join in sql
SQL
0 vote138 views1 answer
Select from another database
SQL
1 vote170 views1 answer
Mysql current running queries
SQL
0 vote156 views1 answer
How to read the potentail error messages in ssis package
SQL