mysql按字符分割字段排序

SELECT slnname, (SELECT REVERSE(LEFT (REVERSE(projectid),LOCATE('G', REVERSE(projectid)) - 1))) AS numb
FROM pmaunew
ORDER BY numb

 

 

 

其他分割:https://www.cnblogs.com/wjm956/p/7724244.html

posted @ 2019-07-28 20:06  雨后丶云初霁  阅读(1150)  评论(0)    收藏  举报