因为如果不用下面的order by field(列名字,数字),则结果是按照id的自然干顺序排的
只有加了下面的order by 后才是按照in里面的顺序排序!
select user.us_fansno as '号',sub.usb_score as '积分'
from b_user user,b_usersub subwhere 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
);