如何在mysql中搜索单个日期?

你可以用 TO_DAYS 要将时间戳转换为天数,请将其与所需的天数进行比较:

SELECT foo FROM mytable WHERE TO_DAYS(timestamp) = TO_DAYS('2009-09-07');

怎么样

SELECT something from mytable WHERE timestamp > 'desiredDate+00:00:00' and timestamp < 'desiredDate+23:59:59'

SELECT myField FROM myTable WHERE timestamp LIKE '2009-08-07%'

获取某一天的所有条目。