title: Count rows in MySQL along with the actual row contents
body: <p>Is there a way in MySQL to do a single SQL statement that returns the selected rows along with the count of the result rows?</p>
  
  <p>I can do this:</p>
  
  <pre><code>SELECT COUNT(*) FROM BigTable WHERE firstname LIKE 'a%';
  </code></pre>
  
  <p>Which gives me a single result row with the count (37,781). I can get the actual row data like this:</p>
  
  <pre><code>SELECT firstname FROM BigTable WHERE firstname LIKE 'a%';
  </code></pre>
  
  <p>which displays the actual 37,781 rows. But when I try to combine them, like this:</p>
  
  <pre><code>SELECT firstname, COUNT(*) FROM BigTable WHERE firstname LIKE 'a%';
  </code></pre>
  
  <p>I get a single row with the first row that matches the query, and the total count of records that matches the query.</p>
  
  <p>What I'd like to see is two columns with 37,781 rows. The first column should contain the first name for each row and the second column should contain the number '37,781' for every row. Is there a way to write the query to accomplish this?</p>