Re: How to count # of occurrences of a char in a string?

At 04:52 PM 12/12/2007, Baron Schwartz wrote: Hi, On Dec 12, 2007 5:39 PM, mos <[EMAIL PROTECTED]> wrote: > I have a Char(50) column and I want to count the number of "." in the > column using a Select statement. I don't see any MySQL function that can > count the number of occurrences of a char

Re: How to count # of occurrences of a char in a string?

Hi, On Dec 12, 2007 5:39 PM, mos <[EMAIL PROTECTED]> wrote: > I have a Char(50) column and I want to count the number of "." in the > column using a Select statement. I don't see any MySQL function that can > count the number of occurrences of a character in a string. Is there a > simple way to do

How to count # of occurrences of a char in a string?

I have a Char(50) column and I want to count the number of "." in the column using a Select statement. I don't see any MySQL function that can count the number of occurrences of a character in a string. Is there a simple way to do this? TIA Mike -- MySQL General Mailing List For list archives