List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:October 22 2008 8:10pm
Subject:Re: MySQL Sort by Array
View as plain text  
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_field

it is
ORDER BY ...
and in this case the ... is the function described above.

On Wed, Oct 22, 2008 at 12:24 PM, Jim Lyons <jlyons4435@stripped> wrote:

> I'm not familiar with "order by field" (unless field is a UDF).  I know of
> order by binary.  Is this standard mysql syntax?
>
> On Wed, Oct 22, 2008 at 10:42 AM, Peter Brawley <
> peter.brawley@stripped
> > wrote:
>
> > ORDER BY id(5, 34, 9, 25)
> >> Can anyone tell me the proper syntax to accomplish this task?
> >>
> >
> > ORDER BY FIELD( id, 5, 34, 9, 25 )
> >
> > PB
> >
> > -----
> >
> > Keith Spiller wrote:
> >
> >> Hi Guys,
> >>
> >> I'm trying to sort by a particular order:
> >>
> >> SELECT * FROM tablename
> >> WHERE id='5' OR id='9' OR id='25' OR id='34'
> >> ORDER BY id(5, 34, 9, 25)
> >>
> >> Can anyone tell me the proper syntax to accomplish this task?
> >>
> >> Thanks for your help.
> >>
> >> Keith
> >>
>  ------------------------------------------------------------------------
> >>
> >>
> >> No virus found in this incoming message.
> >> Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database:
> >> 270.8.2/1739 - Release Date: 10/22/2008 7:23 AM
> >>
> >>
> >>
> >
>
>
> --
> Jim Lyons
> Web developer / Database administrator
> http://www.weblyons.com
>



-- 
Rob Wultsch
wultsch@stripped
wultsch (aim)

Thread
MySQL Sort by ArrayKeith Spiller22 Oct
  • Re: MySQL Sort by ArrayPeter Brawley22 Oct
    • Re: MySQL Sort by ArrayJim Lyons22 Oct
      • Re: MySQL Sort by ArrayRob Wultsch22 Oct
      • Re: MySQL Sort by ArrayBill Newton23 Oct
        • Re: MySQL Sort by ArrayMoon's Father24 Oct
Re: MySQL Sort by ArrayUwe Kiewel22 Oct