I'm trying to update a table column, all I want to do is add 1 to the numeric value it holds. How can I do this without first selecting its current contents? This would cut my number of queries in half.
AndrewLoe.com - Journal - Photos
A relative update
UPDATE table SET column=column+1 WHERE whatever='something';
Try something like:
UPDATE tableName SET fieldName = fieldName + 1 WHERE...
edited : sorry... must have added a reply at same time as Ed Sullivan (great minds think alike, fools seldom differ!!!)