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

I’ve got a table with a BLOB column. What I want to do is get it to be able to pick out words and list them in order.

For example if it contained:

  • Bob Smith likes cheese but loves reading
  • Charlie likes chocolate milk
  • Charl loves manga but also likes cookies

Then I would get

  1. likes
  2. loves

as a result… is this possible and if so how?

I’d like to be able to do it in just mysql alone, but I can use php as well.

Thanks in advance,
kenny

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