mysql query to select all rows of current month?

Question

I have a columns name startdate which is of datetime type.And i have to fetch all rows between start date and end date of a current month.Which is from 1/nov/2014 to 30/Nov/2014.

Answer 1

select * from your_table
where year(curdate()) = year(startdate)
and month(curdate()) = month(startdate)