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, name
FROM mytable
WHERE 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;