On Mon, 2006-08-14 at 05:43 -0700, Steffan A. Cline wrote:
> Here is a better example
>
> mysql> select listName from listItem limit 3;
> +-+
> | listName|
> +-+
> | PWC |
> | Small Boats |
> | Fiberglass |
> +-+
> 3 rows in set (0.02 sec)
>
> mysq
> I want to have the rows returned as one row
> Such as
> ROW 1 Mechanic, Carpenter, Plumber
You may want to try GROUP_CONCAT(expr) ...
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
I think what you are looking for is GROUP_CONCAT. Without more info I can't
really tell though.
http://dev.mysql.com/doc/refman/4.1/en/group-by-functions.html
- Original Message -
From: "Steffan A. Cline" <[EMAIL PROTECTED]>
To:
Sent: Sunday, August 13, 2006 6:53 PM
Subject: Joining r
On Sun, 2006-08-13 at 15:53 -0700, Steffan A. Cline wrote:
> I am in a situation where I have say 1 column called "attribute" I need and
> the result set is 3 rows. i.e.
> ROW 1 - Mechanic
> ROW 2 - Carpenter
> ROW 3 - Plumber
> I want to have the rows returned as one row
> Such as
> ROW 1 Mechani
