一个varchar 的字段 存放 1,2 11等
将字段*1或者+0可以将MySQL字符串字段按数值排序
select * from table where 1 order by id+0 desc;
select * from table where 1 order by id*1 desc;
将字段*1或者+0可以将MySQL字符串字段按数值排序
select * from table where 1 order by id+0 desc;
select * from table where 1 order by id*1 desc;