how to bulk remove posts from Uncategorized category | bulk remove category wordpress, bulk edit categories wordpress plugin,wordpress bulk remove uncategorized,bulk move categories wordpress,wordpress remove category from multiple posts,woocommerce bulk remove category , woocommerce bulk edit categories , wordpress bulk assign categories
it some times happen when you moving posts from blog to another blog and all categories marks in Uncategorized category , if posts be many for example more than 100 and more it is hard to uncheck them manually , so what should we do ?
for this there is many wordpress plugins but all of them needs to check & uncheck manually . if you know very basic knowledge in SQL you can use this query in PHPMYADMIN
SELECT * FROM `wp_term_relationships` WHERE `term_taxonomy_id` IN ( SELECT `term_taxonomy_id` FROM `wp_term_taxonomy` WHERE `taxonomy` = 'category' ) GROUP BY `object_id` HAVING ( COUNT( `object_id` ) >1 )
when you put and run it it will show you all posts that marked in Uncategorized category , and Uncategorized category arry is usually 1
now you should first click on Number or Rows and set it to high number for example 250 , then click on term_taxonomy_id it will sort by number 1 to increase , now just select tables with term_taxonomy_id 1 and delete them . finish !