I have a trigger similar to this
CREATE TRIGGER modTRIGGER AFTER UPDATE OF field1,field2,field3 ON myTABLE BEGIN UPDATE myTABLE SET modDATE=datetime() WHERE key=old.key
Does this fire when any one (Field1, Field2 or Field3) changes? or do they ALL have to be changed?
If I do an UPDATE and set the values to what they already are does this fire?