title: How do I query Last Week From Thursday to Wednesday?
body: <p>I am trying to get a query to pull records from last week from thursday morning at 12:00AM to Wednesday night at 12:00pm. </p>
  
  <p>This needs to always run and be current. I have another query for the current week from thursday to wednesday and it actually works. I just need another query that shows results after the week has passed from last week. </p>
  
  <p>I believe this query is for last week but not starting on Thursday and ending on Wednesday. </p>
  
  <pre><code> SELECT collector, SUM('amountcollected') as 'totalsum' FROM commissioninfo 
     WHERE thedate &gt;= Curdate() - INTERVAL Dayofweek(Curdate())+6 day 
     AND thedate &lt; Curdate() - INTERVAL Dayofweek(Curdate())-1 day  
     GROUP BY collector ORDER BY totalsum DESC
  </code></pre>