mysql group_concat limit results code example

Example 1: group_concat limit mysql

//if you can want increase the group_contat max length
SET SESSION group_concat_max_len = 1000000;

Example 2: group_concat mysql limit issue

DB::statement('SET GLOBAL group_concat_max_len = 1000000');