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

Come October 2023, MySQL 5.7 will no longer receive updates or security patches. It’s time to understand your options and plan for the path ahead. MySQL is the most popular open source database in the ...