MySQL String Last Index Of
I开发者_如何转开发 am able to use LOCATE
to get the index of a character such as a .
in www.google.com
. Thus I can use substring to strip out everything before the first .
.
Is there a way I can look for the last /
?
So I can get test.htm
out of http://www.example.com/dev/archive/examples/test.htm
?
I do not want to say the 6th slash, I want to say the last slash. Can this be done?
Use substring_index
select substring_index('http://www.example.com/dev/archive/examples/test.htm','/',-1)
精彩评论