Mysql查詢資料返回排序

例如有這樣一條語句

select uid from user where uid = 70 or uid =68 or uid = 69;

mysql返回的是

68
69
70

如何讓mysql返回

70
68
69

這樣的結果,就是按照where的條件先後來返回.

回複內容：

例如有這樣一條語句

select uid from user where uid = 70 or uid =68 or uid = 69;

mysql返回的是

68
69
70

如何讓mysql返回

70
68
69

這樣的結果,就是按照where的條件先後來返回.

SELECT id, nameFROM mytableWHERE name IN ('B', 'A', 'D', 'E', 'C')ORDER BY FIELD(name, 'B', 'A', 'D', 'E', 'C')

網上隨便找下就有了

select uid from user where uid in( 70 ,68 , 69) order by fine_in_set('uid','70,68,69');

select uid from user where uid = 70 or uid =68 or uid = 69 order by uid desc

select uid from user where uid = 70 or uid =68 or uid = 69 order by uid desc;

