Re: How to count the number of ,br>'s in multiple records

[Paul DuBois]

At 5:59 PM -0500 9/16/01, Deryck Henson wrote:
>ASP

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
>- http://www.comp-u-exchange.com
>----- 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: [phone]   Fax: [phone]   Cell: [phone]
>>
>>  MySQL 3.23.41-max: up 10 days, processed 200,628,017 queries (215/sec.
>avg)


-- 
Paul DuBois, paul@stripped