列出最常用的关键字

Question

I have a mysql table with these columns: id, text, keywords.

ID is an id. Text is a title. Keywords is a list of tags in this format: tag1 tag2 tag3.

How would I go about getting a list of the most used keywords in the column? Eg. if I wanted to build a tag cloud from all the items in the table.

Answer 1

A simple way would be to create an array where each key is tag#. The value of each of those keys is the number of times tag# appears in the database; this would involve traversing through each tag in the database.