ent: 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:
Dan Nelson wrote:
--snip--
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
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
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
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'
Keith Spiller írta:
Hello,
RE: Sort Select by List
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 wi
2:28 PM
Subject: Re: Sort Select by List
order by office
On Dec 16, 2006, at 3:25 PM, Keith Spiller wrote:
Hello,
RE: Sort Select by List
I'm wondering how I would turn three different queries:
SELECT * FROM team WHERE office = 'Exec'
SELECT * FROM team WHERE of
Hello,
RE: Sort Select by List
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 o