Getting sql result as Array

Question

Is it possible in MySQL to query from a database and get the result as Array?

QUERY

SELECT foo.name,
(
   SELECT data 
   FROM bar 
   WHERE id=foo.userid
) data  
FROM table1 foo;

Expected Output

+---------+------------------------+
| name    |  data                  |
+=========+========================+
| john    |  ['one','two','three'] |
| martha  |  ['one','five','nine'] |
+---------+------------------------+

thanks!

One array, or an array per row? What should the array look like? The output you specify doesn't make that clear. — GolezTrol
– GolezTrol, Commented Sep 22, 2014 at 8:31
I believe this is out of the scope of a classic relational DBMS, research for ORM (Object Relational Mapping) frameworks (e.g., Hibernate), they should help you with this task. — the_marcelo_r
– the_marcelo_r, Commented Sep 22, 2014 at 8:32
Array representation is different in some languages. You need to specify your need exactly to get help. — mrcrgl
– mrcrgl, Commented Sep 22, 2014 at 9:02

Edi G. · Accepted Answer · 2014-09-22 08:34:10Z

2

You can use GROUP_CONCAT

SELECT foo.name,(SELECT GROUP_CONCAT(data SEPARATOR ',') 
                   FROM bar 
                  WHERE id=foo.userid
               GROUP BY data) AS data 
  FROM table1 foo;

answered Sep 22, 2014 at 8:34

Edi G.

2,4207 gold badges25 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting sql result as Array

QUERY

Expected Output

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

QUERY

Expected Output

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related