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" <[EMAIL PROTECTED]>
>To: "Deryck Henson" <[EMAIL PROTECTED]>
>Cc: "MySQL" <[EMAIL PROTECTED]>
>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, <[EMAIL PROTECTED]>
>> 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.
>avg)
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
