limit på group_concat?

Fra http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html

"The result is truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of 1024. The value can be set higher, although the maximum effective length of the return value is constrained by the value of max_allowed_packet."

Lader til at vi snakker max. 1024 karakterer.

Hvordan sætter man den til noget nyt?

SET SESSION group_concat_max_len = xxxxx;