Ignore default values in update statement

[dominique]

I have a timestamp column "sold" with a default value of CURRENT_TIMESTAMP.

Is there a way in an update statement to tell it to not update the sold column? For instance, if I do "UPDATE table SET quantity = 2;" the sold column takes on the current time. I'd like it to keep its old value.

[r937]

UPDATE table SET sold=sold, quantity = 2

[dominique]

Thanks! I didn't know you could do that!