[摘要]+----------+1 row in set查询一周内的数据mysql> SELECT title FROM table WHERE datediff(FROM_UNIXTIME(date...
+----------+
1 row in set
查询一周内的数据
mysql> SELECT title FROM table WHERE datediff(FROM_UNIXTIME(date),now()) > -7;
+------------------------------------+
关键词:MySQL查询时间日期的办法与函数