Thanks Dan,
It is a very small table. I really appreciate you help.
Keith
----- Original Message -----
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Mark Leith" <[EMAIL PROTECTED]>
Cc: "Pintér Tibor" <[EMAIL PROTECTED]>; "[MySQL]" <mysql@lists.mysql.com>
Sent: Saturday, December 16, 2006 9:48 PM
Subject: Re: Sort Select by List
In the last episode (Dec 16), Dan Nelson said:
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");
Oops. I only read the replies and not the original post. Assuming
there are many other values for the "office" field, you might want
SELECT * FROM team WHERE office = 'Exec' UNION
SELECT * FROM team WHERE office = 'VP' UNION
SELECT * FROM team WHERE office = 'Dir';
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
