'Order by parent and children
I am looking at ordering my rows by their respective parent child relationships. One question has been answered that gets me half way and works but only for 2 levels. See How do I order by parent then child?
As you can see the accepted answer mentions that it only works for 2 levels.
Here is my currently query.
My database looks like this.
| car_taxonomy_ID | car_taxonomy_parent | car_taxonomy_title |
|---|---|---|
| 1 | 0 | Title |
| 2 | 1 | Title |
| 3 | 2 | Title |
| 4 | 2 | Title |
| 5 | 1 | Title |
SELECT *
FROM car_taxonomy AS feat
ORDER BY CASE
WHEN car_taxonomy_parent = 0 THEN car_taxonomy_title
ELSE (
SELECT car_taxonomy_title
FROM car_taxonomy AS parent
WHERE parent.car_taxonomy_ID = feat.car_taxonomy_parent
)
END,
CASE
WHEN car_taxonomy_parent = 0 THEN 1
END DESC,
car_taxonomy_title
But I have one more level to retrieve. What must be modified to get that third level
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
