从日期=今天的表中选择* [英] Select * from table where date = today

问题描述

需要有关PHP/MySql的帮助.需要从今天"中选择所有记录.

Need help with PHP/MySql. Need to select all the records from 'today'.

我的桌子上有一个列，上面放着一个unixtime戳，我只想从unixtime戳=今天的表中选择.

My table has a coloumn which holds a unixtime stamp and I want to just select from the table where the unixtime stamp = today.

很乐意在linux命令行上执行此操作，只需要基本的MySql查询?

Happy to do this on linux command line just need to basic MySql query?

推荐答案

我会选择SQL版本:

SELECT * FROM table WHERE DATE(timestamp_field) = CURDATE();

SELECT * FROM table WHERE DATE(timestamp_field) = CURDATE();

这篇关于从日期=今天的表中选择*的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！