Thanks for the question and thanks to Hugo for the detailed explanation.

This could be a useful code to set some fields from a a few restricted rows to some value and the rest to NULL in a single UPDATE statement.