Jak będzie wyglądało sortowanie warunkowe jeżeli moja tabela wyglada tak:
ID | TITLE | PARENT | ORDER |
-----------------------------------
1 | N1 | 0 | 2 |
-----------------------------------
2 | N2 | 0 | 3 |
-----------------------------------
3 | P1 | 1 | 1 |
-----------------------------------
4 | P3 | 1 | 2 |
-----------------------------------
5 | N3 | 0 | 1 |
-----------------------------------
6 | P2 | 1 | 3 |
-----------------------------------
7 | P4 | 2 | 1 |
-----------------------------------
8 | P5 | 2 | 2 |
I chciałbym osobno posortować wszystkie PARENT = 0 wg ORDER później PARENT =1 wg ORDER itp. Wynik powinien wygladać tak:
ID | TITLE | PARENT | ORDER |
-----------------------------------
5 | N3 | 0 | 1 |
-----------------------------------
1 | N1 | 0 | 2 |
-----------------------------------
2 | N2 | 0 | 3 |
-----------------------------------
3 | P1 | 1 | 1 |
-----------------------------------
4 | P3 | 1 | 2 |
-----------------------------------
6 | P2 | 1 | 3 |
-----------------------------------
7 | P4 | 2 | 1 |
-----------------------------------
8 | P5 | 2 | 2 |