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

What is Heartbleed Bug

It is basically a security bug (buffer overread) which is in the Open SSL implementation which is used by a looooooooot of websites on the internet to secure ( :) ) the communication between browser and website.

Jacob on stackexchange explained this issue in detail. Read his answer at superuser.com