The Stack Overflow question https://stackoverflow.com/questions/23750620/update-values-based-on-case-statement has been closed as a duplicate of How to update values using case statement, which has itself been closed as a duplicate of the first.
This is normally prevented, and the only difference to normal seems to be the dupehammer used in one of them.