Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
yep, except for the syntax you have it right. 'Manuals' hyperlink at the very top of this page, then look for an SQL manual to find out the exact syntax for an update. You should include a WHERE clause to insure that you only UPDATE rows that you want and not all rows in the table.
The parenthesis in the SET statement are not required.