mysql in 排序

SELECT * FROM my_table WHERE id IN (30, 20, 80, 40) ORDER BY FIELD(id, 30, 20, 80, 40);

posted @ 2014-11-07 11:24  七郎  Views(436)  Comments(0)  Edit  收藏  举报