在sql语句做查询的时候,用到IN语句时,当需要按照IN里面的串进行排序时以下语句可以进行过滤:
mysql版本:
select a.catentry_id from catentry a where a.catentry_id in (1001095,1001107,1001086) order by find_in_set(a.catentry_id,'1001095,1001107,1001086')
Oracle版本:
select a.catentry_id from catentry a where a.catentry_id in (1001095,1001107,1001086) order by instr(a.catentry_id,'1001095,1001107,1001086')