MySQL 中 String 转化为 数字进行操作

字段属性：str_number

1. 方法

1. str_number + 0
2. str_number * 1
3. CAST(str_number, SIGNED)
4. CAST(str_number, UNSIGNED )
5. cast(CONVERT(t_p_value, DECIMAL(28, 10)) as unsigned)
6. CONVERT(str_number, SIGNED)
7. CONVERT(str_numberUSING gbk))
8. CONVERT(str_numberUSING utf8))
   类似这种方法很多等等

CAST() 和 CONVERT() 函数转换数据类型, 其数据类型范围为:

BINARY[(N)]
CHAR[(N)]
DATE
DATETIME
DECIMAL
SIGNED [INTEGER]
TIME
UNSIGNED [INTEGER]

2. 排序

对于整数这里基本上都适合

对于浮点数这里的只有 CONVERT(str_numberUSING utf8)) 这类的适合