PROS! Finding out what field was updated?

[brianb]

hello pros,

I was wondering if there was a way through MySQL to find out what field what updated in a TABLE?

For instance, I have a TABLE with 3 fields, one of them gets updated...how can I tell which was updated?

Thanks in advance.

[brianb]

Any ideas on this one?

[brianb]

Anyone have any ideas on this?

[diego25]

The field should be right in the SQL string, shouldn't it? e.g.

UPDATE tableName SET field2='something'

So the updated field will be "field2"...so just parse the SQL string or something like that.

Diego