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, ...

Oracle has pushed out MySQL 5.6, a development milestone release of the open-source database management system. MySQL, the development of which has been stewarded by Oracle since its takeover of Sun, ...