mysql获取连续时间间隔,mysql - 根据时间间隔查询来获取计数值 - SO中文参考 - www.soinside.com...

我有表就像这样：

p_central_ticket

================

- t_id ======> id ticket

- t_open_by ======> name that raise the ticket

- t_closed_by ======> name that closed the ticket

- t_open_time ======> open ticket time

- t_closed_time ======> closed ticket time

我应该怎么做，如果我想显示计数的所有车票关闭的名字，和关闭时间的今天，每周，每月和每年的？像这样 ：

Name today weekly monthly yearly

=================================================================

test1@random.com 2 10 70 1000

test2@random.com 5 14 60 1234

样本数据 ：

t_id t_open_by t_closed_by t_open_time t_closed_time

===========================================================================

1 amir@random.com test1@random.com 2018-03-28 2018-03-29

2 tiki@random.com test1@random.com 2018-04-28 2018-05-29

需要帮助的家伙...谢谢