[RESOLVED] quickie : adding a number to all records

[VisionsOfCody]

is there a query structure that will enable me to add, say, 10 to all records in a certain column without doing 2 queries for each record (one to get the current value and one to update it with the new value) ?

sort of like

"UPDATE table SET field+=10"

does something like that exist ?

thanks

[Lars_Berg]

UPDATE t 
      SET column = column + 10

[VisionsOfCody]

thanks 🙂