MySQL如何把varchar类型字段转换成int类型进行倒叙排序

SELECT * FROM sheet2 t1 WHERE t1.`金额`+'0' ORDER BY t1.`金额` DESC;

posted @ 2020-10-27 22:08  悬崖上的金鱼  阅读(754)  评论(0编辑  收藏  举报