title: MySQL date between last monday and the next sunday
body: <p>i'm looking to find all records that have a booking date between the previous monday and the next sunday in MySQL.</p>
  
  <p>So far I have:</p>
  
  <pre><code>SELECT firstname
       , lastname
       , sessions
       , (SELECT COUNT(memberid) 
            FROM bookings
           WHERE m.memberid = b.memberid  
              and b.date between lastMonday and nextSunday) as sessionsused 
    from members
  </code></pre>
  
  <p>I'm looking what to substitute into the lastmonday and nextsunday</p>
  
  <p>Any help is much appreciated!</p>