title: In mariadb the Count(*) AS something doesn't work. Is there a better way to express this?
body: <p>The current mariadb does not allow the following code the COUNT(*) AS something.
  Is there anyway to resolve this please.</p>
  <pre><code>$db-&gt;prepare('SELECT COUNT(*) AS msgCount FROM messages');
  </code></pre>