mysql查询结果拼接成字符串

来源:互联网 发布:土豆视频mac 编辑:程序博客网 时间:2024/04/30 11:14
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
0 0