Hello all,

I have 2 columns, total and last_value

can I do something like

UPDATE values SET total= total+3 WHERE id = 1

from the above query the total is the current total, can I do that in one query or first I have to get the current value in a query and then make a second one to update the value?