MySQL如何从今天记录的表中选择数据? [英] MySQL How to SELECT data from table which recorded today?

问题描述

使用PHP和MySQL.在我的表中，NOW()sql函数记录了日期字段(datetime).此字段中数据的示例值为 2010-10-07 10:57:36 .我如何选择今天的某月某月某日的所有数据.我尝试使用如下代码:

Use PHP and MySQL. In my table, there is date field (datetime) recorded by NOW() sql function. Example value of data in this field is 2010-10-07 10:57:36. How can I SELECT all data which day-month-year is today. I try to use code as below:

  SELECT * FROM table WHERE date=????

推荐答案

SELECT * FROM table where DATE(date)=CURDATE()

这篇关于MySQL如何从今天记录的表中选择数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！