NYCPHP Meetup

NYPHP.org

[nycphp-talk] OT: Random MySQL question

Adrian Noland anoland at indigente.net
Wed Feb 14 13:46:52 EST 2007


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.



More information about the talk mailing list