>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
>
>
