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
