Many thanks for the quick replies! This solution appears the most elegant:
-- Forwarded message --
From: Markus Grossrieder [EMAIL PROTECTED]
Date: 2008/7/1
Subject: Re: force row to appear at top of results using order by
To: Andrew Martin [EMAIL PROTECTED]
Andrew,
something
SELECT events_groups_id, events_groups_name FROM events_groups
ORDER BY IF(events_groups_id=1,0,1),events_groups_name ASC;
-Original Message-
From: Andrew Martin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 9:20 AM
To: mysql@lists.mysql.com
Subject: force row to appear at top of
-Original Message-
From: Andrew Martin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2008 9:20 AM
To: mysql@lists.mysql.com
Subject: force row to appear at top of results using order by
Hello,
I have an order by question...
This is the raw data...
mysql SELECT events_groups_id,