php - Displaying only data from a mysql database that is from todays date

Question

I want to filter my results using PHP to display only data from a table that was inserted TODAY. The format is as follows:

column date in table daily in the format 2013-01-06 17:36:11. How would I filter queries using PHP to only display queries on todays date?

Answer 1

WHERE DATE(`date`) = DATE(NOW())