Hey, folks -- I'm hoping there's a MySQL guru who can help me with this. I want to create a query that will look for a string in my posts, and -- if that string appears -- put that post in a particular category.
I thought I could figure it out, but because of the way WP stores categories among the terms, term_relationships, and term_taxonomy tables, I couldn't.
To be more specific, I'd like to search my posts for any occurrence of the word "embed" and put those posts in the "video" category.
Is this possible? If someone can offer a MySQL query to do it, or point me in the direction to figure it out, I'd be grateful!