mysql字符串排序问题

Answer 1

第一种：select * from qx_cate order by id desc；
第二种：select from qx_cate where id != 16 union all select from qx_cate where id = 16;

Answer 2

order by cast(replace(path, ',', '') as unsigned integer)

You need to pay attention to the situation when path exceeds the range of int, or find another way

Answer 3

Because the path is based on Alphabetical Sorting
The main question is Natural Sorting
There are related solutions online, you can find it yourself