Increasing numeric values without SELECT?

[Jack_McSlay]

well this is the deal... I want to track a lot of site statistics and I remember there is a syntax that allows to increase a certain value in a database with just an UPDATE command but don't remember how it looks like

does anyone know? I need to update several entries sometimes and I don't want to ruin the execution time by reading and writing several entries with php code.

[laserlight]

try something along the lines of
UPDATE col SET col=col+1 WHERE rowid=2;