title: Select all data from the last 5 days
body: <p>In mysql I need to obtain all the last 5 days records.
  So if I have</p>
  
  <pre><code>Name       date
  aaaa      20/11/2010
  dddd*      24/11/2010*
  bbbb      22/11/2010
  cccc      23/11/2010
  eeee*     25/11/2010*
  ffff*      26/11/2010*
  </code></pre>
  
  <p>I need only the last 5 days records.</p>
  
  <p>I tried something like:</p>
  
  <pre><code>SELECT name,date 
  from Lineas
  WHERE date &gt;= DATE_SUB(CURDATE(), INTERVAL 5 DAY)
  ORDER BY date DESC
  </code></pre>
  
  <p>but it isn´t working....</p>