How to select date range of current month from mysql?

[tiburblium]

Greetings,

I am trying to make a select statement that will only get records from the current month. The dates are all stored in mysql in the standard format (yyyy-mm-dd), is there anyway to compare this field with a current month function?

Thanks!

[devinemke]

assuming your date field is called "date"

SELECT * FROM table WHERE YEAR(date) = YEAR(CURDATE()) AND MONTH(date) = MONTH(CURDATE())