[thelist] SQL query help

[Tarrant Costelloe]

Hello, I have a table in a database which holds a DATE value like so,
2002-11-08. I have been trying to write an SQL statement that will pull out
a row based on a column named hits,where the row holding the most 'hits' for
the current month is selected. The 'hits' column holds an INTEGER.

So something like this I guess? SELECT * from TABLENAME where DATE = month
ORDER BY hits DESC"

My problem occurs is the that date value is of a day, so I need to know how
I can commpare it to the current month.

Kind Regards

Taz