title: comparing dates by month and year in mysql
body: <p>I have a table containing data about events and festivals with following columns recording their start and end dates.</p>
  
  <ul>
  <li>Start_Date</li>
  <li>End_Date</li>
  </ul>
  
  <p>date format is in <code>YYYY-MM-DD</code>. I need to fetch event details with the following condition.</p>
  
  <ul>
  <li>Need to fetch all events which start with a current month and there end dates can be anything say <code>currentDate+next30days</code>.</li>
  </ul>
  
  <p>I am clear about end date concept. but not sure how I can fetch data whose start dates are in a current month.
  For this, I need to compare current year and current month against the <code>Start_Date</code> column in my database.</p>
  
  <p>Can anyone help me to point out as how I can do that?</p>