mysql命令varchar字段为整数 [英] mysql order varchar field as integer

问题描述

我的表中有一个varchar字段，我想对其进行排序.但是我需要将此字段作为整数处理.意思是如果按文本排序的顺序是"19,2,20"，但我想获得正确的顺序"2,19,20".

I have a varchar field in my table and I want to sort it. But I need to handle this field as integer. Meaning if sort as text the order is "19,2,20" but I want to get the right order "2,19,20".

有人可以帮助我吗?

推荐答案

我不知何故无法使用CAST运行查询.我总是得到Error Code: 1064 near "DECIMAL"(或我选择的其他数字类型).因此，我找到了另一种将varchar排序为数字的方法:

I somehow didn't manage to run the query with CAST. I was always getting Error Code: 1064 near "DECIMAL" (or other numeric type that I chose). So, I found another way to sort varchar as numbers:

SELECT *
FROM mytable
ORDER BY ABS(mycol)

更简单一些，并且适合我的情况.

A bit simpler and works in my case.

这篇关于mysql命令varchar字段为整数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！