title: MySQL Query for certain date range
body: <p>i'm having the following table data:</p>
  
  <pre><code>Table: Seasons                
  id   from        to
  ---------------------------
  1    2013-08-30  2013-09-04
  2    2013-09-05  2013-09-08
  3    2013-09-09  2013-09-20
  </code></pre>
  
  <p>i need to run a query which returns all records which are within a certain date range, for example: return all records which are affected from <code>2013-09-04 to 2013-09-05</code></p>
  
  <p>it would be like</p>
  
  <pre><code>date  range:                    | 09-04 - 09-05| 
  seasons:          08-30 - 09-04 | 09-05 - 09-08     | 09-09 - 09-20
  </code></pre>
  
  <p>so it should return the first 2 records.
  i've tried the query with BETWEEN but it seams i need to build up several cases - or is there a simpler way?
  thankx</p>