mysql - 如何在MySQL中按月，年排序？

Question

我有数据类型为 varbinary 的月份和年份列。

我试过:

SELECT * FROM traffic
WHERE '2015'<= year AND year <='2015'
    AND NOT (
       ( 2015= year AND month <05) OR
        ( 2015= year AND month >11)
    ) ORDER BY Year, month;

输出是:

month
10
11
5
6
7
8
9

但是我想要

month
5
6
7
8
9
10
11

我该怎么做才能获得预期的输出？

Answer 1

您需要将月份字符串转换为 int

order by cast(month as unsigned)