人們用不同的技巧來(lái)做這件事。我在谷歌上搜索并發(fā)現(xiàn)了一些結(jié)果，每個(gè)結(jié)果都遵循不同的技巧?？纯此麄儯?/trans>
編輯：
我剛剛為未來(lái)的訪問者添加了每個(gè)鏈接的代碼。
MySQL中的α數(shù)字排序
給定輸入
1A 1a 10A 9B 21C 1C 1D
預(yù)期產(chǎn)出
1A 1C 1D 1a 9B 10A 21C
查詢
Bin Way
===================================
SELECT
tbl_column,
BIN(tbl_column) AS binray_not_needed_column
FROM db_table
ORDER BY binray_not_needed_column ASC , tbl_column ASC
-----------------------
Cast Way
===================================
SELECT
tbl_column,
CAST(tbl_column as SIGNED) AS casted_column
FROM db_table
ORDER BY casted_column ASC , tbl_column ASC
MySQL中的自然排序
給定輸入
Table: sorting_test
-------------------------- -------------
| alphanumeric VARCHAR(75) | integer INT |
-------------------------- -------------
| test1 | 1 |
| test12 | 2 |
| test13 | 3 |
| test2 | 4 |
| test3 | 5 |
-------------------------- -------------
預(yù)期產(chǎn)出
-------------------------- -------------
| alphanumeric VARCHAR(75) | integer INT |
-------------------------- -------------
| test1 | 1 |
| test2 | 4 |
| test3 | 5 |
| test12 | 2 |
| test13 | 3 |
-------------------------- -------------
查詢
SELECT alphanumeric, integer FROM sorting_test ORDER BY LENGTH(alphanumeric), alphanumeric
混合字母數(shù)字值的數(shù)值排序
給定輸入
2a, 12, 5b, 5a, 10, 11, 1, 4b
預(yù)期產(chǎn)出
1, 2a, 4b, 5a, 5b, 10, 11, 12
查詢
SELECT versionFROM version_sortingORDER BY CAST(version AS UNSIGNED), version;
希望這能幫上忙
