Hi,
I'm trying to remove loads of sub-categories out of a category up to the top level using sql in phpmyadmin as it'll take ages to do each one through the admin panel. So far I have
SELECT `categories_id` , `parent_id` , `categories_status`
FROM `categories`
WHERE `parent_id` =224
AND `categories_status` =1
which brings up all the categories I need to move, but I don't know what else to add on the end to remove the parent_id.
Any help appreciated!
Bookmarks