①:字符串截取查询 排序
select * from * where farmid = 21 ORDER BY -substring(turbinename, 1) asc
ORDER BY -substring(字段, 1) asc
1
100
2
200
加上-后 字符串的排序是 1 2 100 200
①:字符串截取查询 排序
select * from * where farmid = 21 ORDER BY -substring(turbinename, 1) asc
ORDER BY -substring(字段, 1) asc
1
100
2
200
加上-后 字符串的排序是 1 2 100 200