title: MySql Trigger - String Comparison in IF Statment
body: <p>I'm running mysql 5.0 and have created a trigger. Roughly as follows:</p>
  
  <pre><code>SET @temp =(SELECT STATEMENT);
  
  IF(@temp = 'true') THEN 
    -code block 1-
  ELSE
    -code block 2-
  END IF;
  </code></pre>
  
  <p>When I run my select statement alone it returns 'true' however in the code above 'code block 2' is being executed. Any idea why?</p>