能否在同一天内随机获取项目?例如:给定一个表格,我想在同一天内随机选择项目,并按日期降序排列。但是,由于order by rand()无法接受分组,因此不知道如何开始或是否可能实现。以下是示例表:
+----+---------------------+ | id | md | +----+---------------------+ | 1 | 2010-06-27 11:26:01 | | 2 | 2010-06-27 11:28:20 | | 3 | 2010-06-27 11:29:46 | | 4 | 2010-06-27 11:30:50 | | 5 | 2010-06-27 12:20:56 | | 6 | 2010-06-27 12:27:42 | | 7 | 2010-06-27 15:14:05 | | 8 | 2010-07-06 01:53:33 | | 9 | 2010-07-06 01:52:52 | +----+---------------------+期望输出为:
+----+---------------------+ | id | md | +----+---------------------+ | 8 | 2010-07-06 01:53:33 | 随机块 | 9 | 2010-07-06 01:52:52 | | 2 | 2010-06-27 11:28:20 | 随机块 | 4 | 2010-06-27 11:30:50 | | 1 | 2010-06-27 11:26:01 | | 6 | 2010-06-27 12:27:42 | | 3 | 2010-06-27 11:29:46 | | 5 | 2010-06-27 12:20:56 | | 7 | 2010-06-27 15:14:05 |
+----+---------------------+