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, ":", ""))