title: MySQL: return "0" & "1" rather than "false" & "true"
body: <p>I need to return <code>true</code> or <code>false</code> rather than <code>1</code> &amp; <code>0</code>, using following query:</p>
  
  <pre><code>select if(u.id is null,false,true) status
  from user u
  limit 10
  </code></pre>
  
  <p>the above query returns <code>status</code> with value 0 or 1 rather than <code>true</code> and <code>false</code>,</p>
  
  <p>Is there any way to fix this?</p>