Hi,

the date is stored as 2011-02-04

I want to retrieve a record (just one) if that date falls within this month - which it does.

is this AND clause correct or have a I fluked it?

Code MySQL:
and MONTH(fs.live_from) = month(curdate() )


bazz