Will Gill Will Gill - 1 year ago 90
PHP Question

mysql: select all entries from a particular month using PHP

I have a mysql database table called


One of the fields is a timestamp, set to default to the current timestamp on the mysql server when the record is created.

I need a SQL query to extract all rows that have a timestamp within a particular month. That is, all records for March, or all records for November, etc.

Answer Source

you have to use monthname()

select * from thetable where monthname(date_field) = 'February'

or month(), but this function will return a number

select * from thetable where month(date_field) = 2
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download