Select, find value and update.

Hi hope someone can help. Is it possible to find the value of something and act upon without it coming back to my php script.

e.g.

at moment

mysql: SELECT value(integer) FROM table.
php: +1 to value(integer)
mysql: UPDATE table SET value = new integer.

Which is fine but I'm sure mysql could do all that without it coming back to the script: Something like this perhaps:

Mysql : UPDATE table SET (value +1)

Have looked in a few books but can't seem to see it?

thanks

 

Try:
UPDATE table SET value=value+1;