Hi,

Is there a possibility to select multiple rows from one table
concatenated as one single row?

Maybe some kind of a function which works like that:

table persons

id name
-------------------------
1 John
2 Mary
3 Chris


select <FUNCTION_NAME?>(select name from persons);

And this query will return only one row with one column containing
'JohnMaryChris'




Maybe there is other way to accomplish this goal?

I'm using Mysql 4.1.22

Thanks for any suggestions,
Pawel

Pawel a écrit :

> Is there a possibility to select multiple rows from one table
> concatenated as one single row?

Look MySQL manual for "group_concat()" function. (I don't remember the
exact syntax, but it should be something along this line).

--
Hugo

On 6 Lis, 15:02, Hugo <h...@nospam.invalid> wrote:

> Look MySQL manual for "group_concat()" function. (I don't remember the
> exact syntax, but it should be something along this line).


Exactly http://dev.mysql.com/doc/refman/4.1/...n_group-concat

Thanks very much!

Pawel