How to make mysql answer in only one line

Question

Possible Duplicate:
MySQL Results as comma separated list
Combine Multiple child rows into one row MYSQL
SQL query to pivot a column using CASE WHEN

enter image description here

I want to make a query like this:

SELECT `name` AS `data` FROM `test_table` WHERE `level` = 1 ORDER BY `id`;

But I want it to answer me in only one line with a ',' ! Like this:

data = a,b,

Without using PHP, is it possible using only MySQL? How? Thank you.

Take a look : [http://stackoverflow.com/questions/1067428/combine-multiple-child-rows-into-one-row-mysql][1] [1]: http://stackoverflow.com/questions/1067428/combine-multiple-child-rows-into-one-row-mysql — swati, May 04 '12 at 06:15

Quassnoi · Accepted Answer · 2012-05-04T06:24:54.437

4

SELECT  GROUP_CONCAT(name ORDER BY id SEPARATOR ';')
FROM    test_table
WHERE   level = 1

edited May 04 '12 at 06:24

answered May 04 '12 at 06:15

Quassnoi

413,100
91
616
614

Woow great! thank you so much ! Can I make GROUP_CONTAT add something different than "," ? – Reacen May 04 '12 at 06:18
Thank's! But `ORDER BY `id`` Won't work if I put SEPARATOR. – Reacen May 04 '12 at 06:20

How to make mysql answer in only one line

1 Answers1