From: Dan Nelson
Date: December 17 2006 4:45am
Subject: Re: Sort Select by List
List-Archive: http://lists.mysql.com/mysql/203981
Message-Id: <20061217044512.GD43992@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

In the last episode (Dec 16), Mark Leith said:
> Pintér Tibor wrote:
> >Keith Spiller írta:
> >>I'm wondering how I would turn three different queries:
> >>
> >>    SELECT * FROM team WHERE office = 'Exec'
> >>    SELECT * FROM team WHERE office = 'VP'
> >>    SELECT * FROM team WHERE office = 'Dir'
> >>
> >>Into one query with the sort order of office = 'Exec', 'VP', 'Dir'...
> >>Thanks,
> >>  
> >order by right(office,1)
> >
> >or make an extra column for ordering
> 
> Or be really smart :)
> 
> SELECT * FROM team ORDER BY office='Exec' DESC,office='VP' DESC,
> office='Dir' DESC;

More efficient would be to use the FIELD function:

SELECT * FROM team ORDER BY FIELD(office,"Exec","VP","Dir");

-- 
	Dan Nelson
	dnelson@stripped