comparing dates by month and year in mysql

Question

I have a table containing data about events and festivals with following columns recording their start and end dates.

• Start_Date
• End_Date

date format is in YYYY-MM-DD. I need to fetch event details with the following condition.

• Need to fetch all events which start with a current month and there end dates can be anything say currentDate+next30days.

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 Start_Date column in my database.

Can anyone help me to point out as how I can do that?

Answer 1

select * from your_table
where year(Start_Date) = year(curdate())
and month(Start_Date) = month(curdate())
and end_date <= curdate() + interval 30 day