dumb timestmap question

[jObE]

Good everyone,

I have a timestamp that updates auto when the record is modified but I alos have another timestamp that i wish to update only when certain data is changed.
I'm not sure what the mysql query is to update the timestmap to the current time.

Can anyone help?

[zhabala]

what about this:

UPDATE table SET column = now()

[Sxooter]

Switch to PostgreSQL and use a trigger?

Otherwise you'll be doing it in PHP.