How to add number to MySQL column??

[techiefreak05]

I have a column in my SQL DB, called zypoints ... how do i ADD to the current value.. lets say you have 5, and you do something where i want it to add 2 to that 5, to make 7, how would i do that?

[hitman6003]

[code]UPDATE table SET column = column + 5 WHERE id = '$id';[/code]