title: mySQL - limit on datetime
body: <p>I have a mySQL table containing matchs and their dates (in a DateTime column).</p>
  
  <p>Is it possible to get all matches from day X to X+n, and then all matches from day X+n to day X+2n...?</p>
  
  <p>I would use that to "limit" my results: If I'm on page 1, I get all matches from day 1 to day 5 (for example), on page 2, I get all matches from day 6 to day 10 etc.</p>
  
  <p>I guess I can't use the <code>LIMIT</code> clause because it only limits rows I get (based on a number of rows I want and not on a number of days)</p>