Text categorization

Question

PHP

Good afternoon.
I would be grateful for a tip on solving such a problem:
a news database with a title and text, it is necessary to determine the category of each news using only content (PHP & MySQL)
I understand that a dictionary is needed, is there something ready somewhere?

Thanks

Answer 1

maybe a simple bike on pure mysql without tricks is enough?

update `news` set `category`='disaster' where `content` like '%катастрофа%' or `content` like '%трагедия%';

Answer 2

In general, this is a Machine Learning topic if you want to distribute content into categories with sufficient quality.