SELECT concat(‘‘,group_concat(option_name )) as option_name,select_id
FROM zuyi_t_search_option group by select_id ORDER BY sort
这样排序是不起作用的。
SELECT concat(‘‘,group_concat(option_name ORDER BY sort )) as option_name,select_id
FROM zuyi_t_search_option group by select_id
这样排序起作用。
原文：http://www.cnblogs.com/sosolili/p/5546814.html