求一简单sql(截取字符串)

Question

select reverse(substring(reverse(url),charindex('/',reverse(url))+1,charindex('/',reverse(url),charindex('/',reverse(url))+1)-charindex('/',reverse(url))-1)) from countertable

Answer 1

reverse() 这个函数用得好 ！
学习

Answer 2

select replace(reverse(substring(reverse('/pub/gzpi/rsxx/t20051215_23010.htm'),charindex('/',reverse('/pub/gzpi/rsxx/t20051215_23010.htm')),
charindex('/',stuff(reverse('/pub/gzpi/rsxx/t20051215_23010.htm'),charindex('/',reverse('/pub/gzpi/rsxx/t20051215_23010.htm')),1,''))-
charindex('/',reverse('/pub/gzpi/rsxx/t20051215_23010.htm'))+1)),'/','')

Answer 3

declare @s varchar(100)
set @s='323232fsd/dfsfas/sdfe/sfe/sfd/sd1f/554'
select replace(reverse(substring(reverse(@s),charindex('/',reverse(@s)),
charindex('/',stuff(reverse(@s),charindex('/',reverse(@s)),1,''))-
charindex('/',reverse(@s))+1)),'/','')