mysql - 我如何按时订购查询

Question

select playing_time from video order by playing_time desc;  

playing_time 的列类型是 varchar(25)示例数据

01:05:22  
21:08  
07:52  
04:31

查询不起作用，它没有按最长时间排序我该如何解决这个问题？

Answer 1

你可以试试:

SELECT playing_time FROM video ORDER BY str_to_date(playing_time,'%k:%s') DESC

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format