下面是什么是最好的方法:
SELECT * FROM users WHERE created >= today;
注意: created是一个日期时间字段。
发布于 2011-03-03 22:52:26
SELECT * FROM users WHERE created >= CURDATE();
但我想你是说created < today
发布于 2011-03-03 22:52:50
SELECT * FROM myTable WHERE DATE(myDate) = DATE(NOW())
阅读更多:http://www.tomjepson.co.uk/tutorials/36/mysql-select-where-date-today.html
发布于 2011-03-03 22:52:14
SELECT * FROM users WHERE created >= NOW();
如果该列是datetime类型。
https://stackoverflow.com/questions/5182275
复制相似问题