At 9:55 PM -0400 4/20/01, Jason Lam wrote:
>Let's say I have a DATE field and in the dataset, I got some dates such as
>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?
WHERE YEAR(date) = 2001 AND MONTH(date) = 2
Paul DuBois, paul@stripped