how to bulk remove posts from Uncategorized category

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

how to bulk remove posts from Uncategorized category

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

how to bulk remove posts from Uncategorized category

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 !

Leave a Reply

Your email address will not be published. Required fields are marked *

*