从mysql中的前一周选择记录 [英] Select records from one week previous in mysql
本文介绍了从mysql中的前一周选择记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SELECT * FROM电子邮件WHERE(DATE(date)= date_sub(date('2011-09-17 00:00:00'),1周))
我做错了什么?谢谢
解决方案
我想你在 1周前缺少
INTERVAL
SELECT *
FROM emails
WHERE(DATE(date)= date_sub ('2011-09-17 00:00:00'),INTERVAL 1周));
这是一个查询,我运行,它的工作原理是 DATE_SUB()
部分:
SELECT *
FROM wp_posts
WHERE post_modified> DATE_SUB(CURDATE(),INTERVAL 4 WEEK);
您可以使用负值去做一个给定日期前的N周查询,这样的事情将会产生k:
SELECT *
FROM wp_posts
WHERE post_modified> DATE_SUB(CURDATE(),INTERVAL -1 WEEK);
或:
code> SELECT *
FROM电子邮件
WHERE(DATE(date)= date_sub(date('2011-09-17 00:00:00'),INTERVAL -1周))
I have data that has a date (Y-m-d H:i:s) column (the type is datetime). I'd like to select all records from 1 week before a date I enter (in the below example: 2011-09-17 00:00:00, but am having some trouble. Here's what I've got:
SELECT * FROM emails WHERE (DATE(date) = date_sub(date('2011-09-17 00:00:00'), 1 week))
What am I doing wrong? Thanks
解决方案
I think you're missing INTERVAL
at the front of 1 week
:
SELECT *
FROM emails
WHERE (DATE(date) = date_sub(date('2011-09-17 00:00:00'), INTERVAL 1 week));
Here is a query that I ran that does work for the DATE_SUB()
part:
SELECT *
FROM wp_posts
WHERE post_modified > DATE_SUB(CURDATE(), INTERVAL 4 WEEK);
You can use a negative value to go do a "N weeks before given date" query so something like this would work:
SELECT *
FROM wp_posts
WHERE post_modified > DATE_SUB(CURDATE(), INTERVAL -1 WEEK);
Or:
SELECT *
FROM emails
WHERE (DATE(date) = date_sub(date('2011-09-17 00:00:00'), INTERVAL -1 week))
这篇关于从mysql中的前一周选择记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文