Tagged Questions
1
vote
1answer
23 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
61 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
280 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
816 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 ...
