MySQL 笔记

2019-08-04 约 108 字预计阅读 1 分钟

法一：CAST

1
SELECT val FROM test ORDER BY CAST(val AS unsigned);

MySQL 5.6 不支持直接 cast 到 integer，所以使用 signed 或者 unsinged。

法二：加减法

1
SELECT val FROM test ORDER BY 0 + val;

1
SELECT val FROM test ORDER BY 0 - val;

1
SELECT val FROM test ORDER BY -val;

同 0 - val

1
SELECT val FROM test ORDER BY --val;

同 0 + val

目录