[RESOLVED] SELECT based on date

[luiddog]

I'm trying to use:

SELECT *, DAYOFMONTH(Date) AS d, MONTH(Date) AS m, YEAR(Date) AS y FROM Events
WHERE m = 10 AND y = 2007
ORDER BY Date

But I get 'Unknown Column m in WHERE' error. I assume it's because it is just defined. Can I use a defined value in WHERE?

[bpat1434]

Just take the definition of m and y (MONTH(DATE) and YEAR(Date)) and use them in the WHERE clause:

WHERE MONTH(Date) = 10
   AND YEAR(Date) = 2007