GROUP_CONCAT将里面拼接的字符串排序

SELECT oam.id , GROUP_CONCAT(oacm.name) category
FROM om_article_manage oam
LEFT JOIN om_article_category_relation oacr ON oacr.article_id = oam.id
LEFT JOIN om_article_category_manage oacm ON oacm.id = oacr.category_id
			
GROUP BY oam.id
ORDER BY oacm.name DESC

 这

posted @ 2016-12-21 15:33  乱码出黑客  阅读(2000)  评论(0编辑  收藏  举报