How to extend group_concat() limit in MySQL & phpMyAdmin

To extend group_concat() limit in MySQL there are two methods, either usingSQLcommand or by setting variable value directly in phpMyAdmin. First I am showing the method of setting variable value in phpMyAdmin.

How to extend group_concat() limit in phpMyAdmin

Before we start, we’ll execute some queries to prepare a database table so that, it will be easier and clear to understand the difference.

Now complete text is displayed in the result. You can count the characters and if you want to test, add some more rows to test the limit.

How to extend group_concat() limit using SQL query in MySQL

The other method of extending group_concat() function character limit is using SQL query. Following is the query that is to be executed to extend limit of group_concat() function character limit upto 2048 characters.