Wait wait!!
I don't want to concatenate column, but the value from a column from many
rows.
> -----Original Message-----
> From: Leif Johnston [mailto:Leif@stripped]
> Sent: sábado, 28 de Junho de 2008 16:44
> To: 'Jorge Bastos'; win32@stripped
> Subject: RE: Offtopic help
>
> Hey Jorge - SQL uses a + as a concatenation function so
>
>
> Select field3 + ';' field4 from tbl where field1=art1 and field2=arg2;
>
> You will have to work through the details - just watch your comma
> placement
> since it is easy to screw up and test in the UI first, not code so you
> can
> see results.
>
> Good luck
>
> Leif
>
> Leif Johnston
> Managing Partner
> Technology Catalyst, LLC
> www.TechnologyCatalyst.com
>
>
>
> -----Original Message-----
> From: Jorge Bastos [mailto:mysql.jorge@stripped]
> Sent: Saturday, June 28, 2008 8:58 AM
> To: win32@stripped
> Subject: Offtopic help
>
> Hi people,
>
> I wounder if anyone can give me a hand.
>
> I want to create a view or function/procedure that returns a string,
> and
> inside that function I have to pass two arguments, and do a SQL
> statement
> like this:
>
>
>
> Select * from tbl where field1=art1 and field2=arg2;
>
> Result=concat(field3 ,';') <= for each record found I need to
> concatenate the result, and return it on the end.
>
>
>
> How can this be possible?
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=1
