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)