group and concatenate in mysql without using group_concat

Asked Apr 10 '13 at 20:35

Active Apr 10 '13 at 20:35

Viewed 531 times

I need to output all reviews for every product grouped by product id.

select product_id, GROUP_CONCAT(distinct text separator '<hr>') as 'Review' from reviews WHERE status = 'A' group by product_id

I ‘m using group_concat mysql function which groups and strings together multiples rows into 1.

The maximum number of characters group_concat outputs after running is 1024. Which is not enough since many product reviews exceed 1024 when combined - resulting in incomplete data. I tried to change group_concat_max_len mysql variable to higher number but don't have super previledges.

Is there an alternative method I can use instead of group_concat?

asked Apr 10 '13 at 20:35

Dmitry

4,143
10
46
57

Why do you need that much data on the client? – zerkms Apr 10 '13 at 20:38
Do you have the privilege for creating user defined functions? – Alex Monthy Apr 10 '13 at 20:39
1

Why can't you do this application-side? – tadman Apr 10 '13 at 21:09
Looks like a duplicate of this: http://stackoverflow.com/questions/2567000/mysql-and-group-concat-maximum-length – vadchen Apr 10 '13 at 21:29

group and concatenate in mysql without using group_concat

0 Answers0