title: mysql count groupings
body: <pre><code>CREATE TABLE `articles_entities` (
    `id` CHAR(36) NOT NULL,
  ....
    `created` DATETIME DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `created` (`created`)
  ) ENGINE=MYISAM DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>I am trying to create a query that gives me the count of records by day.. e.g </p>
  
  <pre><code>Day 1: 23 
  Day 2: 343 
  etc...
  </code></pre>
  
  <p>Please note the output is not the exact format I want, just a display of what data I want.</p>