Count number of / in a string

[tidou]

Hello

I want to count the number of / in a string.

Exemple :

I have a column that contain one row with this data :

c:/test/test2

I want that my select column from table output me the number of . in each column.

So with my example c:/test/test2 it should outpout me 2

I don't want to count the number of / in php I want to do this work in MySQL it's faster.

Thanks in advance

[alfoxy]

I have no idea how to do that with MySQL, personally I would definately just do it with a simple PHP loop.

Al

[laserlight]

personally I would definately just do it with a simple PHP loop

In PHP [man]substr_count/man would be used instead of manually writing a loop to count.

Unfortunately I've never tried constructing such a search in SQL, and my search of the MySQL docs dont provide any good leads.

[tidou]

thanks for searching but there is no such function to do that with MySQL and I doens't want to do that with php for speed reason.

So I have use MySQL Replace function to do what I want in a different way and it works great but I find that MySQL should have such usefull function because doing something directly in the database is faster that doing it with a language like php

Topic Close 😉