At 5:59 PM -0500 9/16/01, Deryck Henson wrote:
You tell us, then. MySQL doesn't have a function to count the number
of instances of a substring within a string. At least I don't
think it does. Does ASP have some kind of function for that?
If so, you can run a SELECT that looks for records containing
"<br>", then use the ASP function to count instances, summed over
each matching record.
>- Deryck H
>----- Original Message -----
>From: "Jeremy Zawodny" <jzawodn@stripped>
>To: "Deryck Henson" <ussj4gohan@stripped>
>Cc: "MySQL" <mysql@stripped>
>Sent: Sunday, September 16, 2001 5:45 PM
>Subject: Re: How to count the number of ,br>'s in multiple records
>> On Sun, Sep 16, 2001 at 05:22:53PM -0500, Deryck Henson wrote:
>> > How do I count the number <br>'s in each record in a field?
>> Using what programming language?
>> Jeremy D. Zawodny, <jzawodn@stripped>
>> Technical Yahoo - Yahoo Finance
>> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>> MySQL 3.23.41-max: up 10 days, processed 200,628,017 queries (215/sec.
Paul DuBois, paul@stripped