mysql 常用命令（二）

按字段排序

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);