Re: [PHP-DB] Counting Words in TEXT field From: leo g. divinagracia iii (ldivinag <email protected>)
Date: 07/25/02

i'd do this in php. less work for the server to do... plain and
simple. this goes back to optimizing queries... you should make the
queries RETRIEVE data, not calculate, or at least minimize it.

JJ Harrison wrote:

> I am using mysql.
>
> Is it possible to count the number of words in a text column?
>
> Or is this a job for php(The info will be going into php anyway)?
>
> I can use $word = explode(' ',$row['text']);
> then use count($word ).
>
> I just ask because mysql *may* be able to do it.
>
>

--
Leo G. Divinagracia III
ldivinag <email protected>

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php