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 <[EMAIL PROTECTED]> 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 <
> [EMAIL PROTECTED]
> > 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
[EMAIL PROTECTED]
wultsch (aim)

Reply via email to