Count Number Of Characters In A String With MySQL
… of a string within another string. Basically, I needed to find all URL's from a table that were more than 3 levels deep (i.e. with 3 … difficult really, all I needed to do was find out the length of the URL string and then subtract the length of the string with the slashes removed. This MySQL statement will give you the URL and the number of slashes in that URL in a table. SELECT url, …
Posted: 30 Sep 2010