RE: force row to appear at top of results using order by

>-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 t

RE: force row to appear at top of results using order by

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

Re: force row to appear at top of results using order by

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]&

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, events_groups_name FROM events_groups; +--+-+ | events_groups_id | events_groups_name | +--+-+ |1 | Personal Ev