Way to store dates with missing days / months in mysql (php)

Question

I want to store dates in mysql, so I set a table like "Date", which is fine, but mysql requires that the full date be provided YYYY-MM-DD.

However, some of my data do not include the day, and some are missing a month. Now I could just use the varchar (10) field, but then it's hard to run queries by date based on data.

Is there any other date format that is not so strong and will allow me to use? or 00, where day / month is not known?

Answer 1

Following Babiker's answer , here's what it says:

- , MySQL , '2014-00-00'.

Answer 2

.