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

[mos]

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: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]