MySQL按数组值排序
我需要运行一个 MySQL 查询，其中的顺序由数组值决定.
I need to run a MySQL query where the order is determined by an array value.
我的数组是可变的，但数组中的值对应于我的数据库表中名为ID"的字段，因此我希望以 ID 顺序 9、1、4 返回结果.
My array is variable but the values in the array correspond to a field in my DB table called 'ID' so I want the result to be returned in the ID order 9, 1, 4.
Array ( [0] => 9 [1] => 1 [2] => 4 )
这在 MySQL 中是否可行，或者是否可以使用数组对 MySQL $result 进行排序?您可以假设唯一返回的值是数组中的值.
Is this possible in MySQL or would it be possible to sort the MySQL $result using the array after? You can assume the only values being returned are those in the array.
推荐答案
ORDER BY field(id, 9, 1, 4);
http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_field
相关文章