排序前sql
SELECT * FROM ws_menu WHERE id IN (1,2,9,10,7,8)
排序前结果
排序后的sql
SELECT * FROM ws_menu WHERE id IN (1,2,9,10,7,8)
ORDER BY FIELD (id,1,2,9,10,7,8)
排序后查询结果
排序前sql
SELECT * FROM ws_menu WHERE id IN (1,2,9,10,7,8)
排序前结果
排序后的sql
SELECT * FROM ws_menu WHERE id IN (1,2,9,10,7,8)
ORDER BY FIELD (id,1,2,9,10,7,8)
排序后查询结果