title: Group by day using the timestamp field
body: <p>My table schema looks like this:</p>
  
  <pre><code>+--------------------+--------------+------+-----+-------------------+-----------------------------+
  | Field              | Type         | Null | Key | Default           | Extra                       |
  +--------------------+--------------+------+-----+-------------------+-----------------------------+
  | id                 | int(11)      | NO   | PRI | NULL              | auto_increment              |
  | name               | varchar(50   | NO   |     | 0                 |                             |
  | modified           | timestamp    | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
  | created            | timestamp    | NO   |     | CURRENT_TIMESTAMP |                             |
  +--------------------+--------------+------+-----+-------------------+-----------------------------+
  </code></pre>
  
  <p>I want to get a count of the names and group by number of names modified by day at the moment I can only group by the full date including the timestamp eg:</p>
  
  <pre><code>SELECT name, count(*) FROM mytable GROUP BY modified
  </code></pre>
  
  <p>Thanks in advance.</p>