sql like 简单问题

[jwda7sgr]

有一个字段 Column_path 有值为1，1|2, 1|2|3..... 11,12,13
写delete语句 delete from table where Column_path like '1%'
就全部删除了，
如何只删除1，1|2, 1|2|3 ,............而不删除11,12,13

[zorou_fatal]

你得自己写个function 来解析

[wdx2008]

delete from table where Column_path like '1l%'
１后面加个Ｌ
只能这样了

[zwkandy]

delete from table where '|'+Column_path+'|' like '%|1|%'

可以不？

[webdiyer]

where Column_path like '1,%' or Column_path like '1|%'

=====================
www.webdiyer.com

[sfar]

有什么规律没有啊，楼主

[erwanfan]

delete from table1
where (Column_path = '1') or (PATINDEX('1|%', Column_path) <> 0) or (PATINDEX('%|1|%', Column_path) <> 0)

[erwanfan]

晕 忘了问了，是不是sqlserver阿
我下面的是sqlserver的，你可以先select一下看看
因为要排除11|12，或者13|21|12等等，所以分别开了

delete from table1
where (Column_path = '1') or (PATINDEX('1|%', Column_path) <> 0) or (PATINDEX('%|1|%', Column_path) <> 0)

[erwanfan]

...又想起来还要加上个

delete from table1
where (Column_path = '1') or (PATINDEX('1|%', Column_path) <> 0) or (PATINDEX('%|1|%', Column_path) <> 0) or (PATINDEX('%|1', Column_path) <> 0)

[jwda7sgr]

where Column_path like '1,%' or Column_path like '1|%' 不行， 1 还是在

[jwda7sgr]

erwanfan(teddyxiong) 你的运行结果true
我研究下给你加分

[zeng_c_h]

又學了一個好函數﹐強人