When I tried to select records for specific month and year when I search I found half a solution

[mysql: select all entries from a particular month using PHP](https://stackoverflow.com/questions/5450814/mysql-select-all-entries-from-a-particular-month-using-php?answertab=oldest#tab-top%20but%20i%20want%20to%20also%20select%20%20particular%20year%20in%20racord)

```
select * 
from thetable 
where monthname(date_field) = 'February'

```

then i modify it following

```
select * 
from payments 
where monthname(date) = 'February' and EXTRACT(date )='2011';

```

but it show error what is correct way to select mounth and year
in my table i store date as `2011-2-4`