I have a date field in a mysql database and i want to pull all records from a month.
is there anyway to specify the month number in a query and for it to check this dat field and retrieve everything from the second month?
Probably; MySQL has quite a few date/time functions. No doubt one or another of them can extract the month.
Funnily enough, the month() command will return the month for a timestamp.