![原数据](https://i-blog.csdnimg.cn/blog_migrate/a8842192aacbc557324fd102f78ac267.png)
![筛选后得到的数据](https://i-blog.csdnimg.cn/blog_migrate/484c7a59a6f8b56b04e4c5a0b86dd5da.png)
SELECT * FROM `menu` where DATE_FORMAT(create_time,'%i')%5 = 0 group by DATE_FORMAT(create_time,'%Y-%m-%d %H:%i');
隔几分钟可以随意更换
SELECT * FROM `menu` where DATE_FORMAT(create_time,'%i')%5 = 0 group by DATE_FORMAT(create_time,'%Y-%m-%d %H:%i');
隔几分钟可以随意更换