List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:May 8 2008 8:51am
Subject:RE: Order Problem
View as plain text  
Perfect.  It worked just how I wanted.
 
Thanks for your help.
 
Neil



> Date: Wed, 7 May 2008 19:54:39 +0200> To: neildtompkins@stripped> Subject:
> Re: Order Problem> From: leannonn@stripped> > Hi,> > You should look at
> the `FIND_IN_SET` function here: >
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_find-in-set> >
> Your query could look like:> SELECT ProductID FROM Products WHERE Enabled= ' Yes' AND
> ProductID > IN(varProductID) ORDER BY FIND_IN_SET(ProductID, varProductID);> >
> Haven't tested it, though...> > > Take care,> Aleksandar
_________________________________________________________________

Discover and Win with Live Search

http://clk.atdmt.com/UKM/go/msnnkmgl0010000007ukm/direct/01/
Thread
Query/Key OptimizationMichael Stearne6 May
  • Re: Query/Key OptimizationMichael Stearne6 May
  • Re: Query/Key OptimizationKrishna Chandra Prajapati7 May
  • question about update/join queryAndy Wallace7 May
    • Re: question about update/join queryAndy Wallace7 May
    • Order ProblemNeil Tompkins7 May
Re: question about update/join queryAndy Wallace8 May
Re: question about update/join queryAndy Wallace8 May
Re: question about update/join queryAndy Wallace8 May
RE: Order ProblemNeil Tompkins8 May
  • Re: Order ProblemMoon's Father20 May
Re: question about update/join queryAndy Wallace8 May