I would suggest you change the structure of your table to have 2 date columns (start_date and end_date).
This way you can use simple date functions from PHP or MySQL to built your query.
A good decision is based on knowledge and not on numbers. - Plato