27,579
社区成员
发帖
与我相关
我的任务
分享
declare @s varchar(100)
set @s='http://yao.xywy.com/goods/90000.htm'
select left(right(@s,CHARINDEX('/',REVERSE(@s))-1),CHARINDEX('.',right(@s,CHARINDEX('/',REVERSE(@s))-1))-1)
declare @s varchar(100)
set @s='http://yao.xywy.com/goods/90000.htm'
select substring(substring(@s, len(@s) - patindex('%/%', REVERSE(@s)) + 2, 100), 1, len(substring(@s, len(@s) - patindex('%/%', REVERSE(@s)) + 2, 100))-4)
得出结果就可以排序了。SELECT * FROM TB
ORDER BY CAST(SUBSTRING(URL,27,LEN(URL)-30) AS INT)