mysql 根据固定字段集合排序

SELECT
  i.id
FROM
  invite_info i,
  shop_info s
WHERE
  i.shop_id = s.id
ORDER BY FIELD(i.id,435,432,433,436)

 

posted @ 2023-03-22 10:15  二次元的程序猿  阅读(33)  评论(0编辑  收藏  举报