mysql - 选择当前日期和一周 InnoDB 之间的日期

Question

我有一个只有一列的表格(到期日期)。我想选择过期日期在今天和下周之间的所有行。我使用的是 MySQL 和 InnoDB 类型。

我尝试这样的事情:

SELECT name, expiration 
FROM exp 
WHERE (expiration BETWEEN(CURRENT_DATE, INTERVAL 1 WEEK));

但是我的语法很糟糕。有错误:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 0, 30' at line 3

Answer 1

试试这个:

SELECT *
FROM exp
WHERE expiration  BETWEEN 
         current_date 
        AND 
         current_date + interval 7 day

演示:--> http://www.sqlfiddle.com/#!2/8598a/2