SQL problem

[X-perimental Concept]

hello, I'm using MySql. I have a table with a field named 'created' (datetime)

for example a record : '2004-04-19 12:13:28'

now i want all the records where the created-date will be in the month of april (and only in the month of april).

Is this possible with sql?

[wdglide]

Have you tried
WHERE MONTH(created) = 4

[X-perimental Concept]

thanks ...

that worked ....