DECLARE @Test TABLE (Name VARCHAR(20))
INSERT @Test SELECT ('MENU_Help')
UNION ALL SELECT ('MENU_Help_Me')
UNION ALL SELECT ('MENU_Help_You')
SELECT * FROM @Test
如何只提取
MENU_Help_Me
MENU_Help_You
INSERT @Test SELECT ('MENU_Help')
UNION ALL SELECT ('MENU_Help_Me')
UNION ALL SELECT ('MENU_Help_You')
SELECT * FROM @Test
如何只提取
MENU_Help_Me
MENU_Help_You
INSERT @Test SELECT ('MENU_Help')
UNION ALL SELECT ('MENU_Help_Me')
UNION ALL SELECT ('MENU_Help_You')
SELECT * FROM @Test
WHERE NAME<>'MENU_HelP'
DECLARE @Test TABLE (Name VARCHAR(20))
INSERT @Test SELECT ('MENU_Help')
UNION ALL SELECT ('MENU_Help_Me')
UNION ALL SELECT ('MENU_Help_You') SELECT * FROM @Test
WHERE Name LIKE 'MENU_Help_' + '%'结果:
MENU_Help_Me
MENU_Help_You
INSERT @Test SELECT ('MENU_Help')
UNION ALL SELECT ('MENU_Help_Me')
UNION ALL SELECT ('MENU_Help_You')
SELECT * FROM @Test
WHERE NAME IN('MENU_Help_Me','MENU_Help_You')
好多不同,怎么就搞不出来呢??呵呵
或者
select * from @Test where len([Name])>10
INSERT @Test SELECT ('MENU_Help')
UNION ALL SELECT ('MENU_Help_Me')
UNION ALL SELECT ('MENU_Help_You')
UNION ALL SELECT ('MENU_yy_Me')
UNION ALL SELECT ('MENU_ry_You')
UNION ALL SELECT ('MENU_ry')
SELECT * FROM @Test
如何只提取,就是想抓两个_ _ 分开这种
MENU_Help_Me
MENU_Help_You
MENU_yy_Me
MENU_ry_You
INSERT @Test SELECT ('MENU_Help')
UNION ALL SELECT ('MENU_Help_Me')
UNION ALL SELECT ('MENU_Help_You')
UNION ALL SELECT ('MENU_yy_Me')
UNION ALL SELECT ('MENU_ry_You')
UNION ALL SELECT ('MENU_ry')
SELECT * FROM @Test
where len(Name)-len(replace(name,'_',''))>1
INSERT @Test SELECT ('MENU_Help')
UNION ALL SELECT ('MENU_Help_Me')
UNION ALL SELECT ('MENU_Help_You')
UNION ALL SELECT ('MENU_yy_Me')
UNION ALL SELECT ('MENU_ry_You')
UNION ALL SELECT ('MENU_ry')
SELECT * FROM @Test
where len(Name)-len(replace(name,'_',''))=2关注,学习