Posted by NC on 11/18/05 22:59

mcyi2mr3@lycos.co.uk wrote:
>
> Is there a faster way to do this where you can get mysql to just add +1
> to whatever value is in the collumn?

Yes:

UPDATE the_table SET the_field=the_field + 1 WHERE [condition]

Cheers,
NC

[Back to original message]