title: Multiple if statements in MySQL trigger
body: <p>If you have multiple if statements within a MySQL trigger, what is the best approach?</p>
  
  <p>Currently my SQL looks like this:</p>
  
  <pre><code>IF NOT (NEW.status &lt;=&gt; OLD.status) THEN
    {my sql}
  
  ELSEIF NOT (NEW.actual &lt;=&gt; OLD.actual) THEN
    {my sql}
  END IF
  </code></pre>
  
  <p>On first sight this seems to work. However, I noticed that when multiple of the (else)if statements are true, only the first one gets executed (just like in PHP, for example).</p>
  
  <p>How can I just use multiple if's, not necessarily elseif's, so that more than 1 statement is executed? Creating multiple triggers with the same action is not possible, at least that is what phpMyAdmin shows. Putting multiple if's in one trigger results in errors.</p>