get all values for a person on 1 row?
This is a discussion on get all values for a person on 1 row? within the MySQL forums, part of the Database Server Software category; --> hello, I have a table with geoff value1 value2 value3 geoff value4 value5 value6 is there a way in ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-18-2008, 11:02 PM
| ||||
| ||||
 get all values for a person on 1 row? 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      |
|
05-18-2008, 11:02 PM
| ||||
| ||||
| Re: get all values for a person on 1 row? 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() |
Linear Mode
