Increase group_concat function length

SET SESSION group_concat_max_len = 1000000; // SESSION
SET GLOBAL group_concat_max_len = 1000000; // GLOBAL

// Advance group_concat (order and separator)

group_concat(name order by name separator ':') from users;

For more information Click Here