title: MYSQL select dates before today
body: <p>I have a SQL statement that expected to select all the days at least seven days before today</p>
  
  <p>I used the code as follows:</p>
  
  <pre><code>SELECT * FROM letter WHERE letter.l_date &gt; DATE_SUB(CURDATE(), INTERVAL 7 DAY)
  </code></pre>
  
  <p>But did not get the desired result. I can not understand what I am going wrong. Can anyone help me Pls.?</p>