Override CURRENT_TIMESTAMP in trigger?

[James B]

Hi,
I have a table with a column 'lastupdate' defined as a TIMESTAMP with default = CURRENT_TIMESTAMP. This worked great until I set up a BEFORE UPDATE trigger in which I DON'T want the lastupdate to be set. (The use case is that I want to basically cancel the update by setting all of the "new" values to the "old" ones.) I figured,

set new.lastupdate=old.lastupdate

would do the trick, but it doesn't work (the column is still updated with the current timestamp - but the other values don't change, so I now the trigger is firing correctly). Is there a way to do this?

Thank you for any insight,
-J