codice:
select * from tabella
where date_format(campo_data,'%Y-%m-%d') = '2007-11-26'