select * from mytable where date like curdate.'%' ;