SELECT * FROM app_version ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(substring(version_code, 2),'.0.0.0'),'.',10)) desc;
版权声明:本文为weixin_44018367原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。
SELECT * FROM app_version ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(substring(version_code, 2),'.0.0.0'),'.',10)) desc;