hello guys

i am trying to count the number of a substring occurences in a string. much like subtr_count

i found the following method, but i don't like it, and i think it is slow


please someone point me to a function or another combination of functions, that will work more efficient and faster

thanks

you think it is slow? it isn't

if you say so i believe you

i thought there is an elegant solution to this in mysql, it seems that it doesn't have a predefined function yet

what's inelegant about it? what would a more elegant function look like?

i ment that you are doing to many operations:
- counting length of the main string
- replacing the substring with nothing in the main string
- counting length of the resulted main string
- the difference of the 2 main strings per length of the substring => nr of occurences

looks complicated to me

if this is the only option available then i'll use this

i hope mysql will pop a new substr_count function in the coming versions