MySQL Sort by Array

[Keith Spiller]

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