Unanswered: Removing categories in Wordpress via phpmyadmin
Sorry to bother you with a remedial sounding question - I'm currently trying to remove categories and posts from those categories from a Wordpress database.
I'm using phpmyadmin to run queries, as Wordpress support suggested running the following:
DELETE * FROM wp_post2cat WHERE category_id=2;
DELETE FROM wp_posts USING wp_posts p1 LEFT JOIN wp_post2cat p2 ON p1.ID = p2.post_id
WHERE p2.post_id IS NULL;
However, it doesn't seem to work, and MySQL help seems to suggest the syntax is wrong.
I'd really appreciate if someone could advise - if possible - on how to correct the query statement, so that I can remove Category ID=23 and all posts associated with that category via editing of the database.
Hopefully it's similar to the above, but I'm not competent enough to know how to do this.