title: SQL - MATCH AGAINST with HAVING and COUNT()
body: <p>does someone knows why this first query works and this second not?</p>
  
  <p>first query (works):</p>
  
  <pre><code>SELECT *, 
         MATCH(username) AGAINST ('ergergergergergerg' IN BOOLEAN MODE) AS _score
  FROM (ci_users) HAVING _score &gt; '0';
  </code></pre>
  
  <p>second query (not working):</p>
  
  <pre><code>SELECT COUNT(id), 
         MATCH(username) AGAINST ('ergergergergergerg' IN BOOLEAN MODE) AS _score 
  FROM (ci_users) HAVING _score &gt; '0';
  </code></pre>
  
  <p>the first query returns exactly 24 rows, the second query returns 0 rows, while i just changed <code>*</code> to <code>COUNT(id)</code></p>