Does anyone know a way of selecting all records from a particular month from a date field in MySQL or a year,

For example i thought the following may work but it does now <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

"SELECT * from table WHERE orderdate = '%-04-%"

Thanks

Stephen

Try something like:

SELECT * FROM TableName WHERE DatePart("m", orderdate) = 4

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

this is what i think id the best solution:

SELECT * FROM table where MONTHNAME(orderdate) = 'April' (if you're using text months)

or

SELECT * FROM table where MONTH(orderdate) = 4

i'm quiote sure that this works.

-- J

P.S. i killed kenny