search

catfan / Medoo

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

I don't sort sql select in medoo #873

Closed pusand closed 5 years ago

pusand commented 5 years ago

I encountered a problem

$values = '5,2,4'; $result = $database->select('movie','*',[ "OR" => [ "id" => explode(',',$values), ] ]);

output 2,4,5 !! but i need output 5,4,2 don't sort

help me. !!

catfan commented 5 years ago

You need to use order by customized order.

Read Order Condition section from https://medoo.in/api/where

"ORDER" => [
    "id" => ["5", "2", "4"]
]
pusand commented 5 years ago

Thank you very much