# Ordering categories using SQL

**URL:** <https://meta.discourse.org/t/ordering-categories-using-sql/111960>\
**Category:** Development\
**Created:** [March 18, 2019, 9:37pm UTC](https://meta.discourse.org/t/ordering-categories-using-sql/111960 "2019-03-18T21:37:48Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![csmu](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/csmu/32/124581_2.png) [@csmu](https://meta.discourse.org/u/csmu)\
**Post date:** [March 19, 2019, 8:19pm UTC](https://meta.discourse.org/t/ordering-categories-using-sql/111960/3 "2019-03-19T20:19:46Z")

</div>

Thanks @pfaffman

Based on your ruby code I came up with

```ruby
def sort_categories_by_name(skip=0)
  
  parents = Category.where("parent_category_id is null")
  position = 0
  parents.order(:name).each do |parent|
    parent.position = position
    parent.save!()
    position += (1+skip)
    children = Category.where(:parent_category_id=>parent.id)
    children.order(:name).each do |child|
      child.position = position
      child.save!()
      position += (1+skip)  
    end
  end
  
  position += -(1+skip)  
  return position
  
end

sort_categories_by_name

```

---

_[View the full topic](https://meta.discourse.org/t/ordering-categories-using-sql/111960)._
