title: Mysql current date trigger
body: <p>I have the following trigger</p>
  
  <pre><code>CREATE TRIGGER `qc_date_trigger` AFTER UPDATE ON `brand`
  FOR EACH ROW BEGIN
  
      IF NEW.brandQC = '1' THEN
          SET @brandQCDate = CURDATE();
      ELSE
          SET @brandQCDate = NULL;
      END IF;
  
  
   END
  </code></pre>
  
  <p>For some reason it does not update my Date field into the current date when QC is = 1. I've checked the mysql doc and it should work. Any ideeas?</p>