title: How to select last 30 days dates in MySQL?
body: <p>Can I list somehow the dates of last 30 days in <code>MySQL</code>? Not from a table!</p>
  
  <p>For example I think about like this:</p>
  
  <pre><code>SELECT date WHERE date BETWEEN SUBDATE(NOW(), INTERVAL 30 DAY) AND NOW();
  </code></pre>
  
  <p>Is that possible?</p>