title: Select values between start date and end date
body: <p>I have a table with some events and each event have a start date and end date. For example:
  Table eventos_sapo</p>
  
  <pre><code>id   titulo imagem startDate endDate
  1    ...    ...    2011-02-12   2015-02-12
  2    ...    ...    2013-02-21   2015-02-12
  3    ...    ...    2014-03-14   2015-02-12
  </code></pre>
  
  <p>I try some queries to get the events between some start and end dates, introduced by the user through my web app, but none of the queries returns the event with <code>id=1</code>. Let's say that the user introduce the start <code>date=2013-01-03</code>and the end <code>date=2015-02-14</code>, should return the events 1,2 and 3, but the event with id=1 is not returned by none of my queries.</p>
  
  <p>Here goes what I tried:</p>
  
  <pre><code>Select id from eventos_sapo where startDate &gt;= '2013-01-03' AND endDate &lt;= '2015-02-14'
  
  Select id from eventos_sapo where startDate BETWEEN '2013-01-03' AND '2015-02-14'
  AND endDate BETWEEN '2013-01-03' AND '2015-02-14'
  </code></pre>
  
  <p>What I have to do, to include the event with id=1, because this event is active.</p>