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!