MySQL order by 怎样按照指定的数组进行排序

gloria created at6 years ago view count: 2411

现在有一段[1,3,2]的数组，想让id排序按照这个数组来。

isabel #

SELECT*   
    FROM `users`   
    WHERE id  
    IN (1,3,2)   
    ORDERBY field(id,1,3,2)

6 years ago

Recent search keywords

Recommend