Incrementing record field value..

[lucidfx]

Is there a way to send a query to tell it just to increment a value?
or do you have to select that record then select that value, increment that value then store then update the db record?

[kparker]

UPDATE my_table set my_column = my_column + 1

[Anon]

very cool, thanks.