SELECT * FROM `product`
WHERE `id` IN (1,3,6,7,9)
ORDER BY FIELD(`id`, 7,1,3,6,9)
字段按照指定 ID 顺序进行排序
SQL语句
438
0
0
2022-08-09
登录后可点赞和收藏
登录后可点赞和收藏