Group concat in mysql

Using group concat you can concat an column in an single row.But group concat length which has a default value of 1024.if you want to increase the size you have to use the below query & then execute the group_concat query.

SET group_concat_max_len = 200000;

SELECT GROUP_CONCAT(title) FROM node WHERE nid IS NOT NULL LIMIT 100