数据库表结构
废话不说,直接上演示代码案例
select * from w_test ORDER BY readCount*1 desc; # 可以直接乘 1 ,结果不变
select * from w_test ORDER BY readCount + 0 desc; # 可以直接加 0 ,结果不变
select * from w_test ORDER BY CAST(readCount AS DECIMAL) desc; # 通过CAST将 varchar 转换成decimal, DECIMAL数据类型用于在数据库中存储精确的数值,金钱一般用作的 decimal
select * from w_test ORDER BY CAST(readCount AS UNSIGNED) desc; # 通过CAST将 varchar 转换成unsigned , unsigned 为“无符号”的意思
select * from w_test ORDER BY CONVERT(readCount,SIGNED) desc; # 通过CONVERT将 varchar 转换成unsigned, 无符号(unsigned)和有符号(signed)两种类型