Categorization of text

Good afternoon.
I will be grateful for the tip the solution to this problem:
database news with title and text, it is necessary to determine the category of each news only use the content (PHP & MySQL)
I understand that the dictionary is there something ready?

Thank you
October 3rd 19 at 04:09
2 answers
October 3rd 19 at 04:11
it may be enough simple bike on a clean mysql without tricks?
update `news` set `category`='disaster' where `content` like '%disaster%' or `content` like '%tragedy%';
the question is more about where to get a list of words like '%disaster%' or '%tragedy%'; - Esmeralda commented on October 3rd 19 at 04:14
Find the normal news site and take out category!

SELECT `id` FROM `article` WHERE `text` LIKE '%category%'; - Wiley.Kilback commented on October 3rd 19 at 04:17
Find a normal news site

News in the category of "tragedy" may contain words unrelated to the tragedy - Esmeralda commented on October 3rd 19 at 04:20
You don't want to think! For example, you can read a couple of news that relate to the tragedies, to see what was likely to be again, the word "occured" and look. - Wiley.Kilback commented on October 3rd 19 at 04:23
To think I may want, do not want the pens to do. After all, someone must have done it. - Esmeralda commented on October 3rd 19 at 04:26
October 3rd 19 at 04:13
In General, this topic is Machine Learning if you want enough to thoroughly distribute the content into categories.
in principle, only the average, which then suggested above. That is, I need a list of keywords in order of importance for categories. - Esmeralda commented on October 3rd 19 at 04:16
The most simple — take RSS for different sites by categories, looking for the most popular words, store them in the database yourself. - Wiley.Kilback commented on October 3rd 19 at 04:19

Find more questions by tags Text processingPHPMySQL