ID によるソート方法

$dsql->SetQuery("SELECT id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath FROM `dede_arctype` WHERE $tpsql ORDER BY sortrank ASC LIMIT $totalnum");

$dsql->SetQuery("SELECT id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath FROM `dede_arctype` WHERE $tpsql ORDER BY substring_index('$typeid',id,1) LIMIT $totalnum");

{dede:channelartlist typeid='1,2,3,4,5,6'} 
{dede:type} 
<li><a href=&#39;[field:typeurl/]&#39; [field:rel/]>[field:typename/]</a></li> 
{/dede:type} 
{/dede:channelartlist}