Re: Sort Select by List - Keith Spiller - com.mysql.lists.mysql

8 messages in com.mysql.lists.mysqlRe: Sort Select by List

Subject:	Re: Sort Select by List
From:	Keith Spiller (lare...@hosthive.com)
Date:	12/17/2006 11:20:06 AM
List:	com.mysql.lists.mysql

Thanks Dan,

It is a very small table. I really appreciate you help.

Keith

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';