Increasing a table field value without reading it's value first (?!)

[adrianTNT]

Hello.

 

If I want to add 20  to a "user_funds" field in the table, is there a way to just tell mysql to increase funds field by 20? instead of creating a recordset first and read the current funds?

 

Thanks.

[.josh]

Assuming you have and know a unique id associated with the column...

 

update tablename set user_funds = user_funds + 20 where id=$x

[adrianTNT]

Yes, and that was the thing I was looking for.

Will try. Thank you.