一个varchar 的字段 存放 1000 100 299 等数字
将字段进行数学计算 例如 1 +1 等,可以将MySQL字符串字段按数值排序
例如:
select * from user order by user_num+1 DESC;
select * from user order by user_num1 ASC;
一个varchar 的字段 存放 1000 100 299 等数字
将字段进行数学计算 例如 1 +1 等,可以将MySQL字符串字段按数值排序
例如:
select * from user order by user_num+1 DESC;
select * from user order by user_num1 ASC;
本文标题:对mysql中字符串字段中存储数字排序
本文链接:https://www.haomeiwen.com/subject/ntbtmxtx.html
网友评论