***BOGO*** force row to appear at top of results using order by

["Andrew Martin" <sublimino@xxxxxxxxx>]

Hello,

I have an order by question...

This is the "raw" data...

mysql> SELECT events_groups_id, events_groups_name FROM events_groups;
+------------------+---------------------+
| events_groups_id | events_groups_name  |
+------------------+---------------------+
|                1 | Personal Events     |
|                2 | Company events      |
|                3 | Deliveries in       |
|                4 | Invoices to pay     |
|                5 | Invoices to receive |
|                6 | Deliveries out      |
|                9 | Online demos        |
+------------------+---------------------+
7 rows in set (0.01 sec)


This is almost the result I require:

mysql> SELECT events_groups_id, events_groups_name FROM events_groups
ORDER BY events_groups_name ASC;
+------------------+---------------------+
| events_groups_id | events_groups_name  |
+------------------+---------------------+
|                2 | Company events      |
|                3 | Deliveries in       |
|                6 | Deliveries out      |
|                4 | Invoices to pay     |
|                5 | Invoices to receive |
|                9 | Online demos        |
|                1 | Personal Events     |
+------------------+---------------------+
7 rows in set (0.00 sec)


I would like this to have Personal Events appear first, and the rest
of the list still be alphabetically sorted like so:

+------------------+---------------------+
| events_groups_id | events_groups_name  |
+------------------+---------------------+
|                1 | Personal Events     |
|                2 | Company events      |
|                3 | Deliveries in       |
|                6 | Deliveries out      |
|                4 | Invoices to pay     |
|                5 | Invoices to receive |
|                9 | Online demos        |
+------------------+---------------------+

Is this possible without using a subquery or union?

Many thanks,


Andy

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx