title: MySql How to use DATE_SUB in Between clause
body: <p>I am having problem while using DATE_SUB for DateTime fields.  I want to use query like this:</p>
  
  <pre><code>SELECT
      * 
  FROM 
      SellBySalesman 
  WHERE 
      userid=37 and 
      sellingDate BETWEEN CURDATE() AND DATE_SUB(CURDATE(), INTERVAL 7 DAY)
  </code></pre>