php - mysql，从 'today'开始对枚举中的天进行排序(滚动)

Question

我有:

enum('Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun')<BR>

我希望能够以“今天”或日期(date_format(%a))开始排序

有没有办法解决枚举的索引并执行 ROL？(抱歉，那里有老式的汇编语言)或者，先用 PHP 做更容易吗？目前我只有一个常规的

SORT BY students.day (the enum field)

Answer 1

你可以在 SQL 中这样做:

select * from sortday
order by 
   (myday + DAYOFWEEK(NOW())) MOD 7;

示例

mysql> select * from sortday;
+----+-------+----------------+
| id | myday | val            |
+----+-------+----------------+
|  1 | Mon   | Text from mo   |
|  2 | Tue   | text from Tue  |
|  3 | Wed   | Text from Wed  |
|  4 | Thu   | day Tue        |
|  5 | Fri   | this is friday |
|  6 | Sat   | its sat        |
|  7 | Sun   | ist sunday     |
+----+-------+----------------+
7 rows in set (0,00 sec)

mysql> select * from sortday order by (myday + DAYOFWEEK(NOW())) MOD 7;
+----+-------+----------------+
| id | myday | val            |
+----+-------+----------------+
|  3 | Wed   | Text from Wed  |
|  4 | Thu   | day Tue        |
|  5 | Fri   | this is friday |
|  6 | Sat   | its sat        |
|  7 | Sun   | ist sunday     |
|  1 | Mon   | Text from mo   |
|  2 | Tue   | text from Tue  |
+----+-------+----------------+
7 rows in set (0,00 sec)

mysql>