mysql order排序

SELECT * FROM `eb_words` order by 
(case when id in(select id from eb_words where id=8) then 0 else 1 end),serial desc;

排序结果可以使id为8的排在前面。