[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