Q:

Make TIMESTAMP column update even though I didn't change anything?

I have a MySql table which has a timestamp column.
The table also has alot of other columns.
I have a "change classified" section on my page.
When users change their classifieds, I want the timestamp to update its timestamp. And it does, but sometimes you don't change a classified at all, you just want it to be "renewed".
How can I make my TimeStamp column update even though nothing has been updated?
Ie:
  UPDATE table
  SET text='hello'
  WHERE table.id='id_here';

In the above example, if the column "text" was already hello, nothing would happen here. The Timestamp wouldn't update.
Any ways around this except adding another column? Any MySql settings?
Thanks

A:

Why don't you just update the timestamp column with timestamp?
  UPDATE table
  SET timestamp = now()
  WHERE table.id='id_here';

Or maybe I am missing part of your problem?

