OK, done this before, but it was a while ago.

I need to add 400 to the value of every row in column xyz in table abc

help?

nevermind, got it

update tablename set field = field+400;