title: mysql date ranges with larger date before smaller date
body: <p>I want to store date ranges to allow for hours of operation to be conditional upon a date range to accommodate for seasonal changes. i was using the following condition</p>
  
  <pre><code>date_start &lt; CURDATE() AND date_end &gt; CURDATE()
  </code></pre>
  
  <p>The problem with this is if the start date is larger(September) than the end date (June) </p>
  
  <p>In my database, I am storing the dates(2017-07-01) as a date but the year is irrelevant(I do not even give the user a chance to select a year in input). I am just storing it as a date for validation purposes (if there is a better way I'm up for it). In the example above the range is between September of the prior year to June of the current year. How can I accommodate this WITHOUT relying on the year. Keep in mind that a date range could simply be January to February of the same year so, I need the flexibility. </p>
  
  <p>I guess i could convert the dates to a mathematical number and see if the values are greater than or equal but this seems like quite a bit of overhead.</p>
  
  <p>What would be an effective way I could query the database to determine that the current date is between the correct start and end dates?</p>