有没有好点的方法解决以下一个问题

Question

select      fileId,artistName,starfrom,sex,starnum,displayName,nameNumber,special,language,uploadtim ,fileext,ptune,pstar,bh ,track,sbh,dotstar 
from iptv_new
order by case fileid
         when 'T000447' then 1
         when 'T000438' then 2
         when 'T000444' then 3
         end

Answer 1

create view vTemp as
select     fileId,artistName,starfrom,sex,starnum,displayName,nameNumber,special,language,uploadtime
   ,fileext,ptune,pstar,bh ,track,sbh,dotstar 
 from iptv_new where fileid='T000447'
union all
 select  
   fileId,artistName,starfrom,sex,starnum,displayName,nameNumber,special,language,uploadtime
   ,fileext,ptune,pstar,bh ,track,sbh,dotstar 
 from iptv_new where fileid='T000438'
union all
 select  
   fileId,artistName,starfrom,sex,starnum,displayName,nameNumber,special,language,uploadtime
   ,fileext,ptune,pstar,bh ,track,sbh,dotstar 
 from iptv_new where fileid='T000444'
go select * from vTemp order by fileIddrop view vTemp

Answer 2

--补充一下
select fileId,artistName,starfrom,sex,starnum,displayName,nameNumber,special,language,uploadtim ,fileext,ptune,pstar,bh ,track,sbh,dotstar 
from iptv_new
where fileid in ('T000438', 'T000444', 'T000447')
order by case fileid
         when 'T000447' then 1
         when 'T000438' then 2
         when 'T000444' then 3
         end

Answer 3

select 
    fileId,artistName,starfrom,sex,starnum,displayName,nameNumber,
    special,language,uploadtime,fileext,ptune,pstar,bh ,track,sbh,dotstar 
from 
    iptv_new 
where 
    fileid=in('T000447','T000438','T000444')
order by
    case fileid 
        when 'T000447' then 1 
        when 'T000438' then 2
        when 'T000444' then 3
    end

Answer 4

select fileId,artistName,starfrom,sex,starnum,displayName,
       nameNumber,special,language,uploadtime,fileext,ptune,
       pstar,bh ,track,sbh,dotstar 
from iptv_new  where fileid in ('T000438','T000444','T000447')
                 order by case fileid
                               when 'T000438'
                               when 'T000444'
                               when 'T000447'
                         end