[ciapug] concating columns of strings

[Dave J. Hala Jr.]

Awesome. Works like charm.   Thanks.


On Thu, 2008-05-01 at 14:12 -0500, Colin Burnett wrote:
> group_concat  :)
> 
> http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat
> 
> 
> Colin
> 
> On Thu, May 1, 2008 at 1:50 PM, Dave J. Hala Jr. <dave at 58ghz.net> wrote:
> > I'd like to find a way to take a column of strings and concat all the
> > values. We what I want to do is analogous to summing a numeric column
> > while grouping.
> >
> > What I do with the numeric column is:
> >
> > SELECT SUM(amount) as total FROM mytable GROUP BY vendor
> >
> > I'd like to do the same thing with a character field. Suppose that the
> > field has a character value of A,B or C. I'd like the query to return
> > "ABC" if there are 3 records with those values for each vendor.
> >
> > Anyone try to do this before? It would appear that the Mysql 4.x concat
> > function is not built for this. Any thoughts?
> >
> > :) Dave
> >
> >
> >
> >
> >
> > --
> > ___
> > Dave J. Hala Jr.
> > President OSIS, Inc.
> > www.osis.us
> _______________________________________________
> ciapug mailing list
> ciapug at cialug.org
> http://cialug.org/mailman/listinfo/ciapug
-- 
___
Dave J. Hala Jr.
President OSIS, Inc.
www.osis.us