Ben türünde bir alan var = date MySQL DB.

Bu YY-m-d biçiminde tarihleri ​​saklayın.

How can I write a query which will get the rows where day is equal to some value, for example 1?
I need to get only first days of months (2009-11-01, 2009-12-01, 2010-01-01...)

Teşekkürler