按此格式的SQL顺序（0：0：0.8）H：M：S.MS - ORDER BY / ASC不工作

Question

$result = mysql_query("
    SELECT `runner`,`finished` 
    FROM `runs` 
    WHERE `gamename`='$_SESSION[game]' 
    ORDER BY finished ASC
");

finished is the time H:M:S.MS

it doesn't sort at all.

Here is the data:

0:0:5.1 
0:0:5.2 
0:0:5.4 
0:0:5.7  
0:0:7.0  
0:0:8.9 
0:0:9.3 
0:0:9.8 
0:10:25.2    
0:13:15.2    
0:1:27.1     
0:1:50.4 
0:2:27.9 
0:5:30.9

Answer 1

Your ordering is probably going screwy because "finished" is a text field. Try converting it to a date field in your order by clause:

...
ORDER BY STR_TO_DATE(finished, '%h:%i:%s.%f')