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");
8 messages in com.mysql.lists.mysqlRe: Sort Select by List
