SELECT GROUP_CONCAT(xx_id) AS xx
FROM
(SELECT xx_id,COUNT(xx_id) AS count
FROM
xxx_xxx_word
WHERE
word_id in (SELECT word_id FROM xxx_at_word WHERE xx_id = 1 AND xx_id != 1 GROUP BY xx_id ORDER BY `count` desc) as a
mysql查询结果拼接成字符串
最新推荐文章于 2025-05-02 18:23:07 发布