title: How to get the number of rows returned from a query?
body: <p>Is there a way that I can get the COUNT(*) of what a query will return? For example:</p>
  
  <pre><code>SELECT * FROM table LIMIT 10 // Query
  SELECT (*) FROM table LIMIT 10 // Query Count
  </code></pre>
  
  <p>This would actually ignore the limit (
  <a href="https://stackoverflow.com/questions/17020842/mysql-count-with-limit">MySQL COUNT with LIMIT</a>). While this might be fine and 'correct' within sql, I need the exact number of rows the query is returning. How would this be done?</p>