Concatenate multiple MySQL rows into one field
query:
SELECT
FROM
`tableA` AS `a`
WHERE ....
a.field1, a.field2, a.field3, ... ,
(
) AS `concat_example`
(
SELECT GROUP_CONCAT( CONCAT_WS( ' : ', b.field1, b.field2, ... ) SEPARATOR ' # ' )
FROM `tableB` AS `b`
WHERE `b`.`field` = `a`.`field`
FROM `tableB` AS `b`
WHERE `b`.`field` = `a`.`field`
) AS `concat_example`
FROM
`tableA` AS `a`
WHERE ....
result:
| 1 | a-field1 | a-field2 | a-field-3 | 4 : 3 # 4 : 1 # 4 : 2 |
| 2 | a-field1 | a-field2 | a-field-3 | 8 : 5 # 9 : 0 # 2 : 2 |
| 3 | a-field1 | a-field2 | a-field-3 | 1 : 1 # 2 : 2 # 3 : 3 |
tags:
MySQL
Author: Mumin | Publication: 2016-01-28 14:02