By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 2 Duplicates: 0 Warnings: 0
Records: 5 Duplicates: 0 Warnings: 0
id |
---|
1 |
2 |
id | owner_id | numbers |
---|---|---|
1 | 1 | 333-555-888 |
2 | 1 | 222-777-666 |
3 | 1 | 555-657-555 |
4 | 2 | 123123 |
5 | 2 | 222222 |
id | numbers | rn |
---|---|---|
1 | 333-555-888 | 1 |
1 | 222-777-666 | 2 |
1 | 555-657-555 | 3 |
GROUP_CONCAT( CONCAT('(SELECT numbers FROM phones WHERE owner_id = ',id, ' AND rn = ',rn, ') AS numbers', rn) ) |
---|
(SELECT numbers FROM phones WHERE owner_id = 1 AND rn = 1) AS numbers1,(SELECT numbers FROM phones WHERE owner_id = 1 AND rn = 2) AS numbers2,(SELECT numbers FROM phones WHERE owner_id = 1 AND rn = 3) AS numbers3 |
Statement prepared
id | numbers1 | numbers2 | numbers3 |
---|---|---|---|
1 | 222-777-666 | 333-555-888 | 555-657-555 |