select * from tabella where date_format(campo_data,'%Y-%m-%d') = '2006-09-26'