MYSQL select all from table where month?

You could use

SELECT create_date FROM table WHERE MONTH(create_date) = 5

php mysql sql

SELECT * FROM your_table WHERE month(create_date) = 5

look at documentationThis query works on datetime type of column

php mysql sql

SELECT * FROM table WHERE MONTH(create_date) = 5

CodeHunter