SELECT * from xxx_table WHERE DATE_FORMAT(date_col,'%Y-%m-%d') = DATE_FORMAT(NOW(),'%Y-%m-%d')
select * from 表where left(字段,10)=CURDATE()
试试这样，，，
