15.11.2009, 21:49
Nothing is wrong with UPDATE, it's the only and fastest way.
You can set multiple fields though: UPDATE table SET foo = 'bar', bar = 'foo' WHERE 1 = 1
You can set multiple fields though: UPDATE table SET foo = 'bar', bar = 'foo' WHERE 1 = 1