mySQL add functions? if any?

[Anon]

Hi,

I have simple question. And I know there is an answer for it somewhere, just can't find it 🙂

I need to add 1 to a field value in mySQL. For example. I have a field that stores the number of items a user has purchased. Instead of looking up the number of items, adding one to it, then updating mySQL...I want to just let mySQL do it.

maybe something like this..

UPDATE cust_purchases SET num_items = ADD(num_items_purchased+1) WHERE cust_id = '1846547';

Can anyone help me out here?

Thanks :-)

[Anon]

UPDATE cust_purchases SET num_items = num_items+1 WHERE cust_id = '1846547'