title: SELECT all rows that are 2 WEEKS old FROM NOW
body: <p>I have a query that selects all rows of data from a table in my database. I am using PHP and MySQL. Instead of grabbing all of the rows in my table, I would like to only grab rows that are between now and two weeks old. How can I do this? I know I would need to add a WHERE clause</p>
  
  <p>My Code So far:</p>
  
  <pre><code>$notifications_query= "SELECT * FROM notifications ORDER BY recieved DESC";
  </code></pre>
  
  <p>The column containing the date that will be used is named 'viewed' and it is in 'datetime' format.</p>
  
  <p>Thanks!</p>