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
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
