From: Pintér Tibor
Date: October 24 2008 10:21pm
Subject: Re: How to count # of character occurrences in a string?
List-Archive: http://lists.mysql.com/mysql/215049
Message-Id: <49024A52.2030509@tibyke.hu>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


> I have a Char column with text data like "ab:cdef:h" and I'd like to 
> count the number of ":" in the column. I can't find an easy way to do 
> it. I thought there should be a MySQL function to do this. Any suggestions?

select length('aa:bb:cc:dd')-length(replace('aa:bb:cc:dd',':',''));

btw ever heard of google?

t