My date format is `year-month-day`, (e.g. `2013-12-01`)

And I want to get all rows that have '12' as the month.

I'm currently using this query but nothing happens:

```
$checkadd = mysql_query("SELECT * FROM awsalesreport WHERE (SUBSTRING(date, 5, 2) = '12')");

```

Thanks for your answers.