Mysql order by in (recommended) and mysqlorder

Mysql order by in (recommended) and mysqlorder

// MySQL statement SELECT * FROM 'mytable' WHERE 'id' IN (111, 111) order by field ('id );

Laravel framework

$ Ids = array (1, 17, 2); $ ids_ordered = implode (',', $ itemIds); $ items = static: whereIn ('id', $ ids) -> orderByRaw (DB: raw ("FIELD (id, $ ids_ordered)")-> get ();

The character sequence (recommended) of mysql order by in is all the content shared by Alibaba Cloud xiaobian. I hope you can give us a reference and support the customer's house.