title: Get a list of dates between two dates
body: <p>Using standard mysql functions is there a way to write a query that will return a list of days between two dates.</p>
  
  <p>eg given 2009-01-01 and 2009-01-13 it would return a one column table with the values:</p>
  
  <pre><code> 2009-01-01 
   2009-01-02 
   2009-01-03
   2009-01-04 
   2009-01-05
   2009-01-06
   2009-01-07
   2009-01-08 
   2009-01-09
   2009-01-10
   2009-01-11
   2009-01-12
   2009-01-13
  </code></pre>
  
  <p>Edit: It appears I have not been clear. I want to GENERATE this list. I have values stored in the database (by datetime) but want them to be aggregated on a left outer join to a list of dates as above (I am expecting null from the right side of some of this join for some days and will handle this).</p>