使用Mysql合并数据时常用的函数是GROUP_CONCAT(expr),但其完整用法应该是:
GROUP_CONCAT([DISTINCT] expr [,expr ...]
[ORDER BY {unsigned_integer | col_name | expr}
[ASC | DESC] [,col_name ...]]
[SEPARATOR str_val])
例如下面的操作语句:
SELECT GROUP_CONCAT(car_id ORDER BY postdate SEPARATOR ' ') AS car FROM ccomment_distinct WHERE user_id='10000582'