title: Update one mysql column when another is edited
body: <p>I'm trying to make a datetime field that automatically gets updated with the current time only if there was a change to a certain field.</p>
  
  <p>It seems I have a syntax error.</p>
  
  <pre><code>CREATE OR ALTER TRIGGER last_progress_date
  ON wp_task_mgr
  AFTER UPDATE  
  AS BEGIN
     IF UPDATE (progress_percentage)
     SET last_progress_date = GETDATE()
  END
  </code></pre>