List:General Discussion« Previous MessageNext Message »
From:Jigal van Hemert Date:March 24 2004 4:12pm
Subject:Re: How to optimize ugly order by?
View as plain text  
From: "Henrik Schröder" <hs@stripped>
> used a lot in various searches, and all results should be ordered by
> membership type, but the order should not be 0-1-2, but instead 1-2-0.

One thing you could do (not very neat IMHO) is to JOIN this query with a
table that contains membershiptype and a sortorder. Then you can ORDER BY
the sortorder of that table...

Regards, Jigal.
Thread
• How to optimize ugly order by?Henrik Schröder24 Mar
  • Re: How to optimize ugly order by?Victor Pendleton24 Mar
    • Re: How to optimize ugly order by?Victor Pendleton24 Mar
  • Re: How to optimize ugly order by?Jigal van Hemert24 Mar
  • Re: How to optimize ugly order by?Tim McDonough24 Mar
  • Re: How to optimize ugly order by?Brent Baisley24 Mar
  • Re: How to optimize ugly order by?Michael Stassen24 Mar
  • Re: How to optimize ugly order by?Dave Dash24 Mar
  • Re: How to optimize ugly order by?Don Read25 Mar
• RE: How to optimize ugly order by?Henrik Schröder24 Mar
  • RE: How to optimize ugly order by?Victor Pendleton24 Mar
• RE: How to optimize ugly order by?Henrik Schröder24 Mar