Reorder Magento categories in database

Reorder Category

// step 1, create temporary table
// get attribute from eav_attribute table, entity_type_id = 3 for category

CREATE TABLE _category_order
SELECT
  e.entity_id AS 'entity_id', 
  ce.value AS 'name',
  e.position AS 'current_position'
  '1' AS 'new_position'
FROM
  catalog_category_entity e 
LEFT JOIN
  catalog_category_entity_varchar ce 
ON 
  e.entity_id = ce.entity_id 
AND
  ce.attribute_id = 41
ORDER BY
  ce.value;

// set proper order
SET @x = 0;
UPDATE _category_order SET new_position = (@x:=@x+1) ORDER BY name ASC

// update Magento table
UPDATE
  catalog_category_entity e
LEFT JOIN 
  _category_order co
ON 
  e.entity_id = co.entity_id
SET
  e.position = co.new_position;