数字以varchar类型存储时,排序会是“1,11,2,28,3,4,5,66,7”;
换一种查询方式
select * from table where id = 1 order by rank*1 ;
结果“1,2,3,4,5,6,11,28,66”;
数字以varchar类型存储时,排序会是“1,11,2,28,3,4,5,66,7”;
换一种查询方式
select * from table where id = 1 order by rank*1 ;
结果“1,2,3,4,5,6,11,28,66”;