title: select where year = specific range of years
body: <p>In my table I have a range of start and end years, example below:</p>
  
  <pre><code>id     start year      end year
  1        2005           2007
  2        2008           2012
  3        2009           2012
  4        1998           1999
  5        2005           2006
  </code></pre>
  
  <p>I want to select only those that are between the years 2005 and 2006</p>
  
  <p>I'm sure this is very simple to someone else but I cannot get my head around it!</p>
  
  <p><strong>EDIT :</strong></p>
  
  <p>Just seen the answers and realised how dumb this question was! For some reason I was thinking that doing that was wrong!</p>