Select partial DATE?

Hello! Let's say I have a DATE field and in the dataset, I got some dates such as 2000-01-01 2001-02-01 2001-02-05 2001-02-06 How would I be able to just select all the 2001-02 entries? Obviously, the month and the year are the same, but the date is not, is there a mysql function to do this?

Re: Select partial DATE?

At 9:55 PM -0400 4/20/01, Jason Lam wrote: Hello! Let's say I have a DATE field and in the dataset, I got some dates such as 2000-01-01 2001-02-01 2001-02-05 2001-02-06 How would I be able to just select all the 2001-02 entries? Obviously, the month and the year are the same, but the date is