title: MySQL TRIGGER NEW.date=NOW() on any columns update except `id` and `name`
body: <p>This </p>
  
  <pre><code>CREATE TRIGGER pubdate BEFORE UPDATE ON `table1` FOR EACH ROW SET NEW.date=NOW()
  </code></pre>
  
  <p>on any column update in <code>table</code> would SET <code>date=NOW()</code>.</p>
  
  <p>How to add exception when updating columns <code>id</code> and <code>name</code>?</p>
  
  <p><strong>Update:</strong> basically run TRIGGER <code>pubdate</code> on update any <code>table</code> column except <code>id</code> and/or <code>name</code>.</p>