NYCPHP Meetup

[David Krings]

Adrian Noland wrote:
> Hi all,
> I have an obscure MySQL question I hope someone can answer:
> 
> I have the following query:
> select id, categories from dd_categories where id in (21, 20, 13, 3, 22, 
> 31);
> 
> I want category 21 to show up first in the list.
> It appears the default order is by id which puts #3 at the front.
> I can't order by category to get what I want, because it is in the
> middle of the alphabet.
> 
> Any help? Thanks.

There are surely better ways, but I default to sorting the result set in 
code. Since you know what you get from your query by asking for 
something that you also provide, you can easily resort by ID the way you 
want.

David