Mass assign categories to CMS articles

[Morrus]

I've recently set up new categories of CMS articles and would like to retrospectively add articles to categories. I can do them manually one at a time, but that takes a long time.

Is there an easy mysql query I can use to add categories to articles based on specific keywords in the article titles?

For example, if the article title contains the word "Football" then add it to the football category (bearing in mind that articles can belong to multiple categories).

Thanks in advance for any help!