That is fine. On Thu, May 8, 2008 at 4:51 PM, Neil Tompkins <[EMAIL PROTECTED]> wrote:
> Perfect. It worked just how I wanted. > > Thanks for your help. > > Neil > > > > > Date: Wed, 7 May 2008 19:54:39 +0200> To: [EMAIL PROTECTED]> > Subject: Re: Order Problem> From: [EMAIL PROTECTED]> > 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/ > -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn