按字段排序
1:select *
from user
where id between 1 and 7
order by id [desc | asc ];
2:select *
from user
where id between 1 and 7
order by field('id', 3,1,2,6,4,7,5);
按字段排序
1:select *
from user
where id between 1 and 7
order by id [desc | asc ];
2:select *
from user
where id between 1 and 7
order by field('id', 3,1,2,6,4,7,5);