title: return mysql boolean as 'yes' or 'no'
body: <p>I have a BOOLEAN type column in my table. I would like to convert the 0/1 to Yes/No when the results are returned.</p>
  
  <p>I found a response on this thread: <a href="https://stackoverflow.com/questions/9547419/echo-boolean-field-as-yes-no-or-other-values">Echo boolean field as yes/no or other values</a></p>
  
  <p>The response mentioned an IF THEN statement, but when I try, I only get a complaint from MySQL that there is a syntax error. Here is the line I am using:</p>
  
  <pre><code>IF qz.quiz_enabled == 1 THEN 'yes' ELSE 'no' AS enabled
  </code></pre>
  
  <p>Here is the error:</p>
  
  <pre><code>use near 'qz.quiz_enabled == 1 THEN 'yes' ELSE 'no' AS enabled
  </code></pre>