mysql - Data validation on curdate() group by error code 1111 -

mysql - Data validation on curdate() group by error code 1111 -

this relatively easy i've been staring @ code long , making mistakes. need validate table has been populated day , query takes today's date - curdate() - against date_pulled column i'm getting error code: 1111. invalid utilize of grouping function. messing up.

select * test max(date(date_pulled))=curdate();

you dont need max here. telling query take date equal current date.

try that:

select * test date(date_pulled)=curdate();

mysql