ysql@lists.mysql.com
> Subject: Re: subquery multiple rows
>
>
>
>
> yea.. almost. but it helped a lot. now i know about those functions
> too. thank you...
>
>
> Nathan Sullivan wrote:
> > I think you want to do something like this:
> >
> > sel
yea.. almost. but it helped a lot. now i know about those functions
too. thank you...
Nathan Sullivan wrote:
I think you want to do something like this:
select prod, group_concat(category separator ', ')
from products
group by prod;
Hope this helps.
On Wed, Apr 07, 2010 at 08:37:04AM
I think you want to do something like this:
select prod, group_concat(category separator ', ')
from products
group by prod;
Hope this helps.
On Wed, Apr 07, 2010 at 08:37:04AM -0700, kalin m wrote:
>
> hi all...
>
> i have a bit of a problem with this:
>
> table products:
>
> --
On Wed, 2010-04-07 at 11:37 -0400, kalin m wrote:
> hi all...
>
> i have a bit of a problem with this:
>
> table products:
>
> --
> prod | category |
> -|
> boots | winter|
> boots | summer |
> boots | spring |
> shoes | spring |
> shoes |
hi all...
i have a bit of a problem with this:
table products:
--
prod | category |
-|
boots | winter|
boots | summer |
boots | spring |
shoes | spring |
shoes | winter|
shoes | fall |
shoes | summer |
--
