quick way to add 1 to an integer value in a mysql table

Hi guys

Does anyone know a quick way to add 1 to an integer value in a mysql
table collumn.

The way i use now is to extract the value from the appropriate collumn
using select then use php to create a new value ($newnumber =
$oldnumber +1) and then insert this back into my table.

Is there a faster way to do this where you can get mysql to just add +1
to whatever value is in the collumn? I have a feeling there is but my
mysql knowledge is a bit patchy.

Any help on this will be greatly appreciated.

Thanks

marc

mcyi2mr3 DeleteThis @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