| List: | General Discussion | « Previous MessageNext Message » | |
| From: | mos | Date: | October 24 2008 10:16pm |
| Subject: | How to count # of character occurrences in a string? | ||
| View as plain text | |||
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? TIA Mike
| Thread | ||
|---|---|---|
| • How to count # of character occurrences in a string? | mos | 25 Oct |
| • Re: How to count # of character occurrences in a string? | Pintér Tibor | 25 Oct |
| • Re: How to count # of character occurrences in a string? | Jim Lyons | 25 Oct |
