mysql的in选择结果过，按照in里面的排序排序

因为如果不用下面的order by field(列名字，数字)，则结果是按照id的自然干顺序排的

只有加了下面的ｏｒｄｅｒ　ｂｙ　后才是按照ｉｎ里面的顺序排序！

select user.us_fansno as '号',sub.usb_score as '积分' 

from b_user user,b_usersub sub 
where user.us_id = sub.us_id 
and user.us_fansno in (
  28296 ,
  1802568 ,
  1167907 ,
  331085 ,
  32336 ,
  608608 ,
  2036032 ,
  875829 ,
  2098730 ,
  1988862
)
order by field(
  user.us_fansno,
   28296 ,
  1802568 ,
  1167907 ,
  331085 ,
  32336 ,
  608608 ,
  2036032 ,
  875829 ,
  2098730 ,
  1988862

);