Adding to a counter value in a db

[shaggycap]

I have a table that I want to update a counter field. However I dont want to use update as it will replace the value, I want to add the new value onto the existing, to increment the value by that amount.

Can I do this with an update statement? or will I have to pull the exisiting value out first and add them up in my code? Just thought there may be a function to do this, as it seems quite a common task.

Thanks

[ryanlwh]

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']UPDATE[/span] table SET field[color=orange]=[/color]field[color=orange]+[/color]$new_value [color=green]WHERE[/color] condition [!--sql2--][/div][!--sql3--]

[shaggycap]

[!--quoteo(post=373320:date=May 12 2006, 04:07 PM:name=ryanlwh)--][div class=\'quotetop\']QUOTE(ryanlwh @ May 12 2006, 04:07 PM) [snapback]373320[/snapback][/div][div class=\'quotemain\'][!--quotec--]
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']UPDATE[/span] table SET field[color=orange]=[/color]field[color=orange]+[/color]$new_value [color=green]WHERE[/color] condition [!--sql2--][/div][!--sql3--]
[/quote]

Great stuff, thank you ryanlwh [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /]