search date month and year only

[garfx]

Hello, i hope you can help

i have a large database all rows are dated "2007-10-04" for example. what query can i use to pull only the rows which are dated in October 2007 for example "2007-10"

thank you

[dougal85]

SELECT * FROM table WHERE datefield LIKE '2007-10%'

[NogDog]

Assuming that the field is a DATE type field, I would do:

SELECT * FROM table WHERE YEAR(datefield) = 2007 AND MONTH(datefield) = 10

[garfx]

thank you