mySQL selecting records due within the next month

I am trying to select all records in a table which have a date between the current date and 1 month ahead.

The date is stored like this DD-MM-YYYY

And the query I have tried:

SELECT * from tablename WHERE renewalDate BETWEEN DATE_FORMAT(CURDATE(),GET_FORMAT(DATE,'EUR')) AND  DATE_ADD(DATE_FORMAT(CURDATE(),GET_FORMAT(DATE,'EUR')), INTERVAL 1 MONTH)

But this do开发者_如何学Pythones not return the correct results.

Is the date stored in an actual date or datetime field? If it's in a char/varchar field, you won't be able to use the BETWEEN syntax, as mysql will just treat them as fixed strings.