title: Only Select Friday and coming Monday in mysql
body: <p>I have assignment on my hand of building an Attendance system which I am doing all right but I am stuck at one place. When counting the leaves, if a person takes a leave on Friday and then take leave again on Monday, then the in between Saturday and Sunday should count as leaves too. </p>
  
  <p>I have been able to extract only the Fridays and Mondays from my table by following query:</p>
  
  <pre><code>SELECT * FROM  `main` WHERE (DAYOFWEEK( DATE ) =2 OR DAYOFWEEK( DATE ) =6 ) 
  AND emp_no =4 AND STATUS ='leave' ORDER BY DATE ASC 
  </code></pre>
  
  <p>but I don't know how to select the Friday and the next Monday <strong>only</strong> so I know that the person was on leave on Friday as well as Monday. </p>
  
  <p>Any help would be appreciated.</p>