数字类型:order by 字段 排序方式
字符串类型:order by cast(字段 as char)
字符串类型的数字:
- order by (字段+0) 排序方式
- order by cast(字段 as unsigned)
ORDER BY
CAST(t_school_rank.school_rank_institution AS CHAR) ASC,
CAST(t_school_rank.school_rank_years AS UNSIGNED) DESC
数字类型:order by 字段 排序方式
字符串类型:order by cast(字段 as char)
字符串类型的数字:
ORDER BY
CAST(t_school_rank.school_rank_institution AS CHAR) ASC,
CAST(t_school_rank.school_rank_years AS UNSIGNED) DESC