List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:October 22 2008 3:42pm
Subject:Re: MySQL Sort by Array
View as plain text  
>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
>
>   

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