I did this once and have since always typed the WHERE first in an UPDATE.