hello,

I have a table with

geoff value1 value2 value3
geoff value4 value5 value6

is there a way in which I can get all the values for geoff in one row?
Is concat the way? Not sure how to use it if it is?

Cheers

Geoff

Geoff Cox wrote:
> hello,
>
> I have a table with
>
> geoff value1 value2 value3
> geoff value4 value5 value6
>
> is there a way in which I can get all the values for geoff in one row?
> Is concat the way? Not sure how to use it if it is?
>
> Cheers
>
> Geoff

GROUP_CONCAT()