Updating numbers in Mysql

[Anon]

Hi All,
I have content viewing system, I want to upgrade it so it will count how many times each content item was viewed.

Is it possible to UPDATE number in the column, (just add 1 to whatever it was). Take whatever the value is add +1 in one Mysql query.

One way it can be done is: read the row and get the number in one query and then add 1 and with another query to update the row.

Can it be done with one query?

Max

[Anon]

Of course it can be done by one SQL statement:

UPDATE table SET column = column + 1 WHERE ( some condition )

Zdenek

[Anon]

It looks simple enough 🙂 thanks Zdenek