MySQL.按字符串 ID 进行数字排序 [英] MySQL. Numeric sort by string ID

问题描述

我正在为飙车比赛制作现场比分.我在数据库中有表

I'm creating live score for dragracing competition. I've got table in database

id      time
k2      16,010
k4      15,11
k25     15,819
k26     15,114
z27     19,696

我需要通过 id 以相反的顺序获取该表.例如，如果选择 SELECT id FROM online order by id desc，结果将被排序为 string.

I need to get that table in reverse order by id. For example, if select SELECT id FROM online order by id desc the result would be sorted as a string.

id
k9
k8
k7
k6
k5
k4
k3
k17
k16
k15
k14

我需要 17-14-9-4

I need 17-14-9-4

更新.谢谢大家！！！这个有帮助

Upd. THANKS FOR ALL!!! This one helped

SELECT CAST( replace( id, 'k', '' ) AS SIGNED ) AS sort
FROM online
ORDER BY `sort` DESC

推荐答案

最终得到这个 :)

SELECT CAST( replace( id, 'k', '' ) AS SIGNED ) AS sort
FROM online
ORDER BY `sort` DESC

这篇关于MySQL.按字符串 ID 进行数字排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！