SELECT * FROM app_version ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(substring(version_code, 2),'.0.0.0'),'.',10)) desc;
mysql 根据版本号排序
最新推荐文章于 2023-03-31 11:49:59 发布
SELECT * FROM app_version ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(substring(version_code, 2),'.0.0.0'),'.',10)) desc;