排序

[baidu_36464328]

mysql中怎么给带有-符号的排序，例如 684-12-00，684-9-10，684-11-00，684-3-00

[致命的西瓜]

mysql 对于字符串是逐个比较，684-3-00会比684-12-00大，转成数字就可以了

[专注打酱油30年]

select @a:='684-12-00', SUBSTRING_INDEX(@a,"-",1) as a,SUBSTRING_INDEX(@b:=SUBSTRING_INDEX(@a,"-",2),"-",-1) as b,SUBSTRING_INDEX(@a,"-",-1) as c;
GROUP BY a, b, c;

[ACMAIN_CHM]

baidu_36464328 本版等级：T1 结帖率：0%

引用

当您的问题得到解答后请及时结贴. http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html 8、如何给分和结贴？ http://bbs.csdn.net/help#post_dispose