Select records from current month

Question

I have a table with a varchar field called slldate. This field contains dates in this format:
2010-08-30
(YYYY-MM-DD)

Now I would like to select the records containing the current month using a mysql query.

Anyone?

Answer 1

as you used a char field instead a date field, you have to cast the value and then use the normal date functions. like

SELECT * FROM table WHERE MONTH(CAST(slidate as date)) = MONTH(NOW()) AND YEAR(CAST(slidate as date)) = YEAR(NOW())

Answer 2

Try this:

SELECT * FROM table_name WHERE MONTH(slldate) = date('m') AND YEAR(slldate) = date('Y');