In the last episode (Jan 21), Steve Edberg said:
> At 12:17 PM -0600 1/21/04, Joseph S Brunzelle wrote:
> > I'm try to write a query that will return the number of times a
> > specified character appears in a string (I want known how many
> > times the character "M" appears), but I cannot seem to figure out
> > how to do that.
>
> To use the counts on a regular basis, it's probably easier to count
> them when you insert or update the record, and store those values in
> a separate column. That's what I ended up doing on a few genetics
> databases I was working on, anyway -
You could also write a UDF to do it, which will be faster than the
replace() idea, but requires you to write C.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
