# 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:** 5

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [March 13, 2021, 1:23pm UTC](https://meta.discourse.org/t/ordering-categories-using-sql/111960/5 "2021-03-13T13:23:53Z")

</div>

Sort of. There are settings to put them in a fixed order. I think you first set a system setting (search for fixed, perhaps) and then you can do it in the ux.

If you have a dozen, it’s not too bad to do it in the ux (that interface has been troublesome and I don’t know how it works these days, so some of this might be wrong), if you have hundreds and won’t change, I once wrote some stuff to run at the console to sort them. If you have lots and change them all the time and want to keep them sorted, you’d need a plugin.

---

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