如何在MySQL数据库表列中查找最常用的单词

Question

i have a table in following format:

id | title
---+----------------------------
1  | php jobs, usa
3  | usa, php, jobs
4  | ca, mysql developer
5  | developer

i want to get the most popular keywords in title field, please guide.

Answer 1

SELECT title 1, COUNT(*) FROM table GROUP BY title 1

EDIT

Since you've edited and presented a non-normalized table, I would recommend you normalize it.