title: MySQL SELECT COUNT > 0 as boolean value
body: <p>I'm trying to get a true/false value in a column in a select statement which indicates if a count is >0 or not.</p>
  
  <p>I read these docs: <a href="http://dev.mysql.com/doc/refman/5.1/en/expressions.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.1/en/expressions.html</a></p>
  
  <p>Which I don't fully understand but they seemed to indicate I could use '>>' in my expression.</p>
  
  <p>So I tried this:</p>
  
  <pre><code>SELECT COUNT(*)&gt;&gt;0 AS my_bool FROM table GROUP BY id;
  </code></pre>
  
  <p>It runs and doesnt generate errors or warnings, however the <code>my_bool</code> column just contains the results of the <code>COUNT(*)</code>. 
  Is what I'm trying to do possible, if so how?</p>
  
  <p>P.S Yes I know I could just test for x>y in my code that handles the results, I want to know if it is something that can be done in MySQL alone (feel free to explain why it's not advisable, by all means)</p>