Is there an SQL code out there which will efasily add or subtract 1 from a numeric feild? I'm finding it frustrating to have to get the data out of the database, add one and then update it...
is it possible to, say use...
UPDATE table SET feild = (field+1) WHERE field_id = $field_id
?