search

catfan / Medoo

The lightweight PHP database framework to accelerate the development.
https://medoo.in
MIT License
4.83k stars 1.15k forks source link

ORDER BY FIELD #202

Closed zlababa closed 8 years ago

zlababa commented 9 years ago

Hi I have a question.

Is possible to create this order sequence?

SELECT code, unit, rate FROM exchange ORDER BY FIELD(code, 'CHF', 'EUR', 'CZK') DESC, code;

catfan commented 9 years ago

Read about Order by field http://medoo.in/api/where