MySQL当查询的时候有多个结果，但需要返回一条的情况用GROUP_CONCAT拼接

2019独角兽企业重金招聘Python工程师标准>>>

SELECT GROUP_CONCAT( name ORDER BY name DESC SEPARATOR ',' ) AS 'lessonTitle'  FROM `edu_train_term` WHERE lesson_ids like '%2199%';

转载于:https://my.oschina.net/u/2358326/blog/492236