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

Question

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

Answer 1

I've re-worked my code so I no longer need to do this... it seems impossible with standart setups