mysql怎么取当天的记录数

[chenhongxin]

大家好，我想取当天的记录数，怎么取。我表里有这样一个字段TIMESTAMP.

[WWWWA]

select count(*) from tt where date(TIMESTAMP)=CURDATE()

[ACMAIN_CHM]

select count(*) from table1 where 字段TIMESTAMP>=CURDATE() ;

[chenhongxin]

就是取出当天的记录。

[hao1hao2hao3]

select * from tablename where TIMESTAMP>=CURDATE() ;

[paula2008]

select count(*) from table1 where substring(字段,1,10)>=substring(now(),1,10) ;

[hitexam]

[Quote=引用 1 楼 wwwwa 的回复:]

select count(*) from tt where date(TIMESTAMP)=CURDATE()
[/Quote]
1楼的不错啊