title: mysql if function - subquery as a condition
body: <p>I believe the following query is self explanatory:</p>
  
  <pre><code>SELECT IF (SELECT COUNT(*) FROM mytable &gt; 0, 'yes', 'no');
  </code></pre>
  
  <p>Why doesn't it work? And how should I correct it?</p>