sql search results by month in format 2010-04-01 10:40:20

Question

How can i select all rows where the month is 04 from 2010 where the format of the date column is as follows: 2010-04-01 10:40:20 using mysql

Accepted Answer

You can use the MONTH AND YEAR functions :

```
SELECT * FROM
table
WHERE MONTH(date) = 4 AND YEAR(date) = 2010
```

Solution