Mysql order by in a particular way!

[amrigo]

Hi!! I want to order by like this:

Quem Somos
Estrutura / Organograma
Locais de Atendimento
Órgãos Vinculados / Conselhos
Órgãos Vinculados / Conselhos
Nominata
Nominata

But with my query it is being ordered like this:

Quem Somos
Órgãos Vinculados / Conselhos
Órgãos Vinculados / Conselhos
Nominata
Nominata
Locais de Atendimento
Estrutura / Organograma

My query is :
SELECT noticia.*, subitem.*
FROM noticia inner join subitem on subitem.cod_subitem = noticia.cod_subitem
WHERE noticia.cod_item=10 ORDER BY subitem.nome DESC

How it can be done ?

Thank´s in advance

[bubbisthedog]

ORDER BY is either ASC or DESC. Period. What you're seeking isn't a sort by any means. I would explore the UNION (ALL) keyword if I were you.