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
>not, is there a mysql function to do this?
>
>In a nutshell, how do I select some DATE type of data just by year
>and month match?
>
>Thanks
>
>Jason Lam
WHERE YEAR(date) = 2001 AND MONTH(date) = 2
--
Paul DuBois, paul@stripped
