mysql In函数确保查出的顺序和传进去的顺序一致

order by field(列名, xxx, xxx)

例如:

SELECT
count( member_id )
FROM
zj_comment_collect
WHERE
story_id IN ( 'AP5d8dd78ee4b073920d8bf561', 'AP5d8dd093e4b0df6e9bc667a1', 'AP5d8dd258e4b0df6e9bc667fc' )
AND thumbs_up_type = 'story'
AND collect = '1'
GROUP BY
story_id
ORDER BY
FIELD( story_id, 'AP5d8dd78ee4b073920d8bf561', 'AP5d8dd093e4b0df6e9bc667a1', 'AP5d8dd258e4b0df6e9bc667fc' )

posted @ 2021-06-18 15:06  FY丶  阅读(208)  评论(0)    收藏  举报