UPDATEmit mehreren WHERE

[Paul]

Sorry ;)

SQL Befehl:

UPDATE t_buch
SET buch=
CASE author
    WHEN 'Hans' THEN 'GUT
    WHEN 'Werner' THEN 'Schlecht'
    ELSE 'normal'
END CASE

WHERE author
IN (
'GUT'
'Schlecht'
'normal'
)

Fehlermeldung:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CASE

WHERE author
IN (
'GUT'
'Schlecht'
'normal'
) at line 7