Put all articles containing a certain word into a certain category in WordPress

lookout said:

Where it says 5 is your category id. The place that says word is the word you are looking for. Don't forget to backup your database!

The following is the SQL code and needs to be executed from phpmyadmin.

INSERT INTO wp_term_relationships (object_id, term_taxonomy_id)
SELECT ID, 5
FROM wp_posts
WHERE post_content LIKE '%word%'
AND post_type = 'post'
AND post_status = 'publish'
AND ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id = 5
)

This SQL code searches for a specific word in your posts and moves all the posts it finds to the category with 5 ids. If you want to search post titles, change post_content to post_title.

Click to expand...