Wednesday, April 30, 2014

find out number of occurrences of a character in mysql

How to find out count of a specific character or a char-sequence in mysql?

There is no simple method available to do that. However we can use below method to find out.

select length(x) - length(replace(x, ":", ""))

No comments:

Post a Comment

Latest Posts