title: Select all dates between two dates not using a table (generate list of dates)
body: <p>Is there a way to get all dates between two dates without using any MySQL table </p>
  
  <p>Something like: </p>
  
  <pre><code>SELECT date BETWEEN '2012-02-10' AND '2012-02-15'   
  </code></pre>
  
  <p>that would result in this:</p>
  
  <pre><code>out put date list
  2012-02-10
  ...
  2012-02-15
  </code></pre>