phpmysqlpopularity

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:

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


Solution

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