title: SQL - Date Between (xxxx-06-21 and xxxx-09-21)
body: <p>How is it possible to use the BETWEEN function in MySQL, to search for dates in <strong><em>any</em></strong> year but between a specific day/month to a specific day/month? Or if it's not possible using BETWEEN, how else could I accomplish it?</p>
  
  <p>To be more descriptive, I am trying to add a seasonal search to my photo archive website. So if a user chose to search for "summer" photos, it would search photos taken between 21 June and 21 September, but from any year.</p>
  
  <p>If Carlsberg made SQL, I think it would be :)</p>
  
  <pre><code>WHERE date BETWEEN 'xxxx-06-21' AND 'xxxx-09-21'
  </code></pre>
  
  <p>Many thanks</p>