title: mysql select 3days records from today
body: <pre><code>SELECT * FROM `user` 
  WHERE name !='' AND `date_created` BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 3 Day ) 
  AND DATE_SUB( CURDATE( ) ,INTERVAL 0 Day ) 
  ORDER BY `date` ASC
  </code></pre>
  
  <p>The above query brings record 3day before from todays date.</p>
  
  <p>but i need 3day records from today,which means tomorrow , day after tomorrow etc.</p>
  
  <p>date_created is mysql date format.</p>