Whether you’re just getting in to programming or you’ve avoided learning SQL, it’s something every developer faces eventually. You may not be responsible for building and maintaining a database, but ...

No, you're not missing something, that is what was originally described as to-do. @MichaelC: the update statement with the case in it seems syntactically correct, but it updates ALL rows in the table, ...