ORDER BY question.

[Anon]

Hi,

Ok, I am pulling all records from a table.

I want to pull them in random order by order by group.

But here is the problem. I need to order them where groupX is first.

IE
groupx = 'friends'

So order contactlist by groups with friends being first.

Any way to do this in a query with having to put in an array and mess around?

Thanks!

[Anon]

order by case when groupx = 'friends' then 0 else 1 end, groupx