I have this update query which updates only one row at a time in my table but it updates quite alot of fields.
Now what I need to do is find out is if a specific one of all those fields has been updated/changed after the query.
I could ofcourse do a select before my update and store the field-value in a variable which I could later test by selecting again after my update has been done but that would mean 2 extra db-queries. Is there a workaround for this ?
The db is MySQL btw.