mysql - Search by month and day mqsql -

i have table messages column date (format datetime) how can search messages date = xxxx-05-09 ?

select * messages date = 'xxxx-05-09'; 

try this:

 select * messages extract(month date) = 5 , extract(day date) = 9;