字段按照指定 ID 顺序进行排序

SQL语句
403
0
0
2022-08-09
SELECT * FROM `product` 
WHERE `id` IN (1,3,6,7,9) 
ORDER BY FIELD(`id`, 7,1,3,6,9)