select * from tabella where date_format(campo_datetime,"%Y-%m-%d") = curdate()