MYSQL select all from table where month?

Use month(Yourdate) to extract the month

SELECT * FROM table WHERE MONTH(create_date) = 5

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_month

SELECT * FROM your_table WHERE month(create_date) = 5

look at documentation This query works on datetime type of column

You could use

SELECT create_date FROM table WHERE MONTH(create_date) = 5

Related