mysql - 查询从当天到 future 7 天的数据返回 null

Question

我得到了如下所示的表格和数据

CREATE TABLE events_calender (
  company_name varchar(30) DEFAULT NULL,
  reg_date varchar(20) 
);

Insert into events_calender values('Childerse Event' , '30-Oct-2015');
Insert into events_calender values('Womens Event' , '05-Nov-2015');
Insert into events_calender values('Mens Event' , '02-Nov-2015');
Insert into events_calender values('DOlls Event' , '02-Oct-2015');

我想返回从当天到 future 7 天的数据(即将发生的事件)

我已经尝试过这个方法了

从 events_calender 中选择 *WHERE reg_date BETWEEN DATE( NOW() ) AND DATE( DATE_ADD( NOW() , INTERVAL 7 DAY ) )

但即使记录存在，实际上也没有返回任何数据

http://sqlfiddle.com/#!9/25bd0/3

Answer 1

声明的错误类型 reg_date varchar(20) 应为 reg_date date:

http://sqlfiddle.com/#!9/22cfe/1

CREATE TABLE events_calender (
  company_name varchar(30) DEFAULT NULL,
  reg_date date 
);

Insert into events_calender values('Childerse Event' , '2015-10-30');
Insert into events_calender values('Womens Event' , '2015-11-05');
Insert into events_calender values('Mens Event' , '2015-11-02');
Insert into events_calender values('DOlls Event' , '2015-10-02');

SELECT * 
FROM events_calender 
WHERE reg_date BETWEEN DATE( NOW() ) AND DATE( DATE_ADD( NOW() , INTERVAL 7 DAY ) )