The group-concatenation tag has no wiki summary.
1
vote
1answer
39 views
Using wm_concat to concatenate rows, but in an order determined by another column
Let's say I have 3 columns: p_id, description, order_by. I am trying to do the following:
I would like to concatenate the description for all like p_id values. So we are talking a group by p_id ...
1
vote
1answer
24 views
Join two group_concat result
this is the query:
$sql = "select pn.id, pn.purchased_number, pn.plan, pn.ring_to_group,
count(rtg.id) as totalGroups,
concat_ws(',', group_concat(rtg.group_name), ...
1
vote
0answers
86 views
How can I join one to one to (many to one) without using group_concat
I have a table structure as follows:
--
-- Table structure for table `emails`
--
CREATE TABLE IF NOT EXISTS `emails` (
`ID` int(5) NOT NULL AUTO_INCREMENT,
`email` varchar(255) COLLATE ...
1
vote
2answers
343 views
Getting repeated value in a group_concat only if ids are different
I have two tables, first the table Product:
id|category_id
--+-----------
1 | 12345
2 | 12345
3 | 12465
And then a table activity:
id|prod_id|activity_type |description
...
2
votes
1answer
954 views
Multiple “GROUP_CONCAT”s with WHERE clause
In a table as
id name type info
1 BMW car yes
2 Reno car no
3 IBM electronics no
4 Sony electronics yes
5 Mazda ...
2
votes
1answer
88 views
SQL ISO Standard for group concatenation
Is there an operator in the latest standard SQL:2011 (or earlier) that will handle group concatenation the likes of which we currently have to resort to these tricks for?
GROUP_CONCAT in MySQL
FOR ...
