Incrementing a value in MySQL

[Sleep Mode]

Hi :) I know the auto_increment property of mysql, but i want to increment a value in the table, when something added to another table.

Should i get the value by select.... and then add it by php. and then update it to the database? is there any easy way for this? Thanks :)

[NogDog]

UPDATE table_name SET column1 = column1 + 1 WHERE column2 = 'some value';