title: MySQL Query Help, Group By Time, See if Record is in set
body: <p>Quick question on how to do this, I'm unsure how it would work. Essentially I have a table with thousands of rows per day, and I want to group them by date for each row. That part is easy, but then I want to know if an instance is in that group, for example I want to know if Paul is on this date.</p>
  
  <pre><code>   Date      Name
   ------------------
  | 4/8/2011 | Jack |
  | 4/8/2011 | Jack |
  | 4/8/2011 | Jack |
  | 4/8/2011 | Jack |
  | 4/8/2011 | Jack |
  | 4/8/2011 | Paul |
  </code></pre>
  
  <p>I've got <code>SELECT count(*) as Total /*not sure what goes here*/ WHERE date = '2011-04-08' GROUP BY date</code></p>