Count # of slashes in a URL

[kernal]

Is it possible to count the number of slashes in a URL? Example:

http://tek-tips.com/threadminder.cfm?pid=436

So I would want it to show 3 since this particular URL has 3 '/' slashes but some URLs could have 4, etc.

Help is appreciated

 

[kernal]

I found this select statement that is working.

Since there is no inbuilt MySQL function to count the occurrence of a character in string, we can do it by using these steps:

1. Counting the number of characters in the original string

2. Temporarily ‘deleting’ the character you want to count and count the string again

3. Subtract the first count from the second to get the number of occurrences

Example:

SELECT LENGTH('foobarfoobarfoobar') - LENGTH(REPLACE('foobarfoobarfoobar', 'b', '')) AS `occurrences`
--> Result: 3

In this example ‘b’ is the string you want to count the number of occurrences.

Thanks