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
