MySQL :- select by month

Question

how can i get record from table using month/year? I have a table like

Project

Name - varchar
DueDate -datetime
Status -boll

DueDate is project due date, i want record corresponding to month/year,not full date, i mean record for specific month.

How can i do this in mysql

Answer 1

SELECT Name FROM Table Where MONTH(datetime) = 1;

1 = January.

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

Answer 2

You can extract the MONTH() and YEAR() for your DueDate.

Answer 3

SELECT * WHERE MONTH(DueDate) = '5' AND YEAR(DueDate) = '1987';

Answer 4

Simply use MONTH() and YEAR():

SELECT * FROM Project WHERE MONTH(DueDate) = 1 AND YEAR(DueDate) = 2010

Answer 5

You could use a between statement:

select * from Project 
  where DueDate between '2010-01-01' and '2010-02-01'