MYSQL select everything from the table, where is the month?

Question

Can I select all fields for a month?

For example: I have a column "create_date" and the values ​​of this column:

2011-05-06 11:12:13 (this) 2012-06-06 13:12:13 2010-02-06 14:52:13 2011-05-06 21:12:13 (this) 2001-08-06 16:12:13 2011-09-06 18:12:43 2009-01-06 11:12:13 2012-02-06 12:17:55 2010-03-06 14:15:13 2012-05-06 11:19:23 (this) 

How to select all fields where month is 05?

Answer 1

you can use

 SELECT create_date FROM table WHERE MONTH(create_date) = 5 

Answer 2

 SELECT * FROM your_table WHERE month(create_date) = 5 

see the documentation. This query works with a datetime column type

Answer 3

 SELECT * FROM table WHERE MONTH(create_date) = 5 

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

Answer 4

Use month(Yourdate) to retrieve the month

Answer 5

just stumbled upon something to be mentioned when using MONTH () it will only get a month from the DATE line. not using unixtimestamp

if you want to use it with unixtimestamp:

  MONTH(FROM_UNIXTIME(create_date)) 

Answer 6

To dynamically filter the current month:

 MONTH(create_date) = MONTH(NOW()) 

Answer 7

Use this query

 SELECT create_date FROM table WHERE MONTHNAME(create_date) = MONTHNAME(now()) 

Answer 8

You can do something like:

 select create_date from "table" where create_date between '2011-05-01' and '2011-05-31';