Counting words?

registered · Posted: Mon Jan 10, 2005 10:13 am

Is there a method to count all of the words within a table?

thanks,
-drmike

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Not in MySQL. If you mean to count all words in all columns, then you would need to set up a loop that uses the php function to count words and cycle through every column of every row.

Posted: Mon Jan 10, 2005 5:05 pm

Well, just a thought. One of the sites I run is a Fiction site with a 80 megs story table. Love to see how many words are in it.

What is the php function to count words anyway? Maybe I'll write it tonight.

Thanks for your help,
-drmike

Posted: Mon Jan 10, 2005 5:34 pm

http://us2.php.net/manual/en/function.str-word-count.php

Posted: Mon Jan 10, 2005 5:40 pm

Thank you. Bookmarked.

I can never find anything when I go to PHP.Net....

Thanks,
-drmike