UPDATE mytable SET myfield = myfield + 1;