Mysql查询数据返回排序

Question

例如有这样一条语句select uid from user where uid = 70 or uid =68 or uid = 69;mysql返回的是686970如何让mysql返回706869这样的结果,就是按照where的条件先后来返回.

Answer 1

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

Answer 2

SELECT id, name

FROM mytable

WHERE name IN ('B', 'A', 'D', 'E', 'C')

ORDER BY FIELD(name, 'B', 'A', 'D', 'E', 'C')