> From: Randal Rust > > Tom > > 43 % Nerd, 60% Geek, 17% Dork > > 100% helpful:) Er, 110%...? <tip type="Giving MySQL's GROUP_CONCAT enough room" author="Max Schwanekamp"> MySQL's GROUP_CONCAT[0,1] function is very useful at times, but it has a default max length of just 1k, so before you use it for anything concatenating anything more than 1 byte values, you might want to increase its value to something a little more useful, e.g.: SET SESSION group_concat_max_len = 8192; [0] http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html [1] http://db4free.blogspot.com/2006/01/hail-to-groupconcat.html </tip> -- Max Schwanekamp 90% Nerd 7% Geek 3% Inert Ingredients