Orcale,MySQL,SqlServer的sql自定义排序

1，SqlServer

#(1)CHARINDEX方式
select * from datasaver where strid in ('16842752','16842753','16842754','16842755','16842756','16908288','16908289','16908290','16908291','16908292','16908293','16908294','16973824','16973825','17039360','17039364','17039362','17039363','17367049','17367050','17367081','17367082','17367083','17367084') 
 order by  CHARINDEX('|' + LTRIM(RTRIM(STR(id))) + '|','16842752|16842753|16842754|16842755|16842756|16908288|16908289|16908290|16908291|16908292|16908293|16908294|16973824|16973825|17039360|17039364|17039362|17039363|17367049|17367050|17367081|17367082|17367083|17367084|')
#（2）case when方式(缺点：when最多只能用10个)
select * from datasaver where strid in ('16842752','16842753','16842754','16842755','16842756','16908288','16908289','16908290','16908291','16908292','16908293','16908294','16973824','16973825','17039360','17039364','17039362','17039363','17367049','17367050','17367081','17367082','17367083','17367084') order by case strid when '16842752' then 1 when '16842753' then 2 ........ else n end

2，Orcale

#1，decode方式
select XZDXDW_ID, decode(XZDXDW_NAME ,null,'',XZDXDW_ID) XZDXDW_NAME from LZ_DIC_XZDXDW order by decode(xzdxdw_id,'TMB',1,'SGC',2,'SKF',3,'LYC',4,'FAG',5,'1厂',6)

3，MySQL

#1,FIELD方式
SELECT  *  FROM user where username in ('zhangsan',   'admin',   'lisi') ORDER  BY  FIELD(username,  'admin',   'zhangsan',   'lisi')