我有以下查询:SELECTseries,scottFROMstampitemdetailsWHEREscottREGEXP'^C[0-9]'ORDERBYSUBSTR(scott,1,1),CAST(SUBSTR(scott,2,100)ASUNSIGNED)它几乎以正确的顺序返回我的行，但是当数字后面有字母时，它们有时是乱序的。其他人似乎订购正确。这是返回的内容:seriesscottAirmailStampsC1AirmailStampsC2AirmailStampsC3AirmailStampsC3aAirmailStampsC4AirmailStampsC5AirmailSta