Advice on a complex MySQL script?

Hello-
I'm trying to figure out a way to count and order by rank all words of an entire book I have stored in a MySQL table.
The entire book is stored in 1 field and is 36,000 rows. Each row has a paragraph of text (a couple sentences). I'm trying to make a query that takes ALL words in the entire book and ranks them by word and count. So far, I only know how to compare and rank exact paragraphs, but wonder if there's a way to explode the words out of each sentence (while disregarding…
Advice on a complex MySQL script?

See original post by electroze