List:MySQL on Win32« Previous MessageNext Message »
From:Jorge Bastos Date:June 28 2008 3:59pm
Subject:RE: Offtopic help
View as plain text  
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


Thread
Offtopic helpJorge Bastos28 Jun
  • RE: Offtopic helpLeif Johnston28 Jun
    • RE: Offtopic helpJorge Bastos28 Jun
  • RE: Offtopic helpJohn Bonnett30 Jun
  • Re: Offtopic helpRandy Clamons30 Jun
    • RE: Offtopic helpJorge Bastos30 Jun
  • Re: group_concat (was: Offtopic help)Markus Grossrieder1 Jul