能否查询的ID号按In中的字符串先后顺序排列

[lingyun410]

Select ID From [Label] Where Label_Name In ('testParent','test child','test')
这样的结果为:
2
3
6
----------------------------------
testParent:id为3
test child:id为6
test :id为2

有办法让输出的ID号按 In 中的字符串先后顺序排列ID号值么？

[水族杰纶]

Select ID From [Label] Where CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')>0
 ORDER BY CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')

[lg3605119]

Select ID From [Label] Where Label_Name In ('testParent','test child','test') 
order by 
  case when Label_Name In ('testParent') then 1 
       when Label_Name In ('test child') then 2 
       when Label_Name In ('test) then 3
       else 4 end 

[lg3605119]

Select ID From [Label] Where Label_Name In ('testParent','test child','test') 
order by 
  case when Label_Name In ('testParent') then 1 
       when Label_Name In ('test child') then 2 
       when Label_Name In ('test') then 3
       else 4 end 

[ks_reny]

[Quote=引用 1 楼 wufeng4552 的回复:]
SQL codeSelect ID From [Label] Where CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')>0
ORDER BY CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')
[/Quote]
支持水哥的.

[sdhdy]

Select ID From [Label] Where CHARINDEX(Label_Name,'testParent,test child,test')>0
ORDER BY CHARINDEX(Label_Name,'testParent,test child,test')

[olddown]

[Quote=引用 1 楼 wufeng4552 的回复:]
SQL codeSelectIDFrom[Label]WhereCHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')>0ORDERBYCHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')
[/Quote]
水哥的秒解啊。

[ai_li7758521]

SELECT ID FROM [Label] 
WHERE CHARINDEX(Label_Name,'testParent,test child,test')>0
ORDER BY CHARINDEX(Label_Name,'testParent,test child,test')

习惯这么写

[Zoezs]

SELECT ID FROM [Label] 
WHERE CHARINDEX(Label_Name,'testParent,test child,test')>0
ORDER BY CHARINDEX(Label_Name,'testParent,test child,test')

[--小F--]

Select ID From [Label] Where CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')>0
 ORDER BY CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')--这个方法很妙
SELECT ID FROM [Label] 
WHERE CHARINDEX(Label_Name,'testParent,test child,test')>0
ORDER BY CHARINDEX(Label_Name,'testParent,test child,test')--常规写法  也不错

[SQL77]

CREATE TABLE TBTEST(ID INT ,LABLENAME VARCHAR(20))
INSERT TBTEST
SELECT 2,'test' UNION ALL
SELECT 3,'testParent' UNION ALL
SELECT 6,'testchild' UNION ALL
SELECT 8,'testbbb'

--DROP TABLE TBTEST

SELECT ID,LABLENAME FROM TBTEST WHERE LABLENAME IN('testParent','testchild','test') ORDER BY RIGHT(LABLENAME,LEN(LABLENAME)-4) DESC
ID          LABLENAME            
----------- -------------------- 
3           testParent
6           testchild
2           test

（所影响的行数为 3 行）

[yingzhilian2008]

[Quote=引用 10 楼 SQL77 的回复:]
SQL code
CREATE TABLE TBTEST(ID INT ,LABLENAME VARCHAR(20))
INSERT TBTEST
SELECT 2,'test' UNION ALL
SELECT 3,'testParent' UNION ALL
SELECT 6,'testchild' UNION ALL
SELECT 8,'testbbb'

--DROP TABLE TBTEST

SELECT ID,LABLENAME FROM TBTEST WHERE LABLENAME IN('testParent','testchild','test') ORDER BY RIGHT(LABLENAME,LEN(LABLENAME)-4) DESC
ID LABLENAME
----------- ----…
[/Quote]
这个很凑巧啊！

[yingzhilian2008]

Select ID From [Label] Where CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')>0
 ORDER BY CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')


SELECT ID FROM [Label] 
WHERE CHARINDEX(Label_Name,'testParent,test child,test')>0
ORDER BY CHARINDEX(Label_Name,'testParent,test child,test')

[htl258_Tony]

[Quote=引用 1 楼 wufeng4552 的回复:]
SQL codeSelect ID From [Label] Where CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')>0
ORDER BY CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')
[/Quote]正解.

[笨沙发]

[Quote=引用 1 楼 wufeng4552 的回复:]
SQL codeSelect ID From [Label] Where CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')>0
ORDER BY CHARINDEX(','+Label_Name+',',','+'testParent,test child,test'+',')
[/Quote]支持