How can I get the most popular words in a table through mysql?

Question

I have a table with a BLOB column. I want him to be able to choose words and put them in order.

For example, if it contains:

• Bob Smith loves cheese, but loves to read.
• Charlie loves chocolate milk
• Charles loves manga but loves cookies.

Then I would get

• like
• loves

as a result ... is it possible, and if so, how?

I would like to be able to do this only in mysql, but I can also use php.

Thanks in advance Kenny

Answer 1

I reworked my code, so I no longer need to do this ... it seems impossible with standard settings

Answer 2

, MySQL MySQL, , , PHP , explode(' ', $myString) str_word_count($myString, 1) , . .

Answer 3

Sphinx Search (http://sphinxsearch.com/) - , mysql, db . , mysql.

, - bash script, :

GET_TOP_X_STOP_WORDS=27
WORD_FREQ_FILE=~/wordfreq.txt
/usr/local/bin/indexer test1 --buildstops $WORD_FREQ_FILE $GET_TOP_X_STOP_WORDS --buildfreqs