Minimizing Queries

[WALoeIII]

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.

[Ed Sullivan]

A relative update

UPDATE table SET column=column+1 WHERE whatever='something';

[lveale]

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!!!)

[WALoeIII]

Thank You

[lveale]

no worries!