group_concat用运 属于同一组统计

http://www.cnblogs.com/wangtao_20/archive/2011/02/23/1961860.html

group_concat()会计算哪些行属于同一组，将属于同一组的列显示出来。要返回哪些列，由函
数参数(就是字段名)决定。分组必须有个标准，就是根据group by指定的列进行分组。

SELECT u.truename,u.city,u.company,u.job,u.about,e.apply_imgs,user.email,group_concat(field_id order by field_id) from user_profile u
          LEFT JOIN expert_apply_new e on u.id = e.userid
          LEFT JOIN user on u.id = user.id
LEFT JOIN field_goodat on field_goodat.user_id = u.id
where e.userid = 51343 and e.check_status = 1 ORDER BY e.apply_time