From: Jorge Bastos
Date: June 28 2008 12:58pm
Subject: Offtopic help
List-Archive: http://lists.mysql.com/win32/18881
Message-Id: <00e001c8d91e$a98f0d70$fcad2850$@jorge@decimal.pt>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00E1_01C8D927.0B537570"

------=_NextPart_000_00E1_01C8D927.0B537570
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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?


------=_NextPart_000_00E1_01C8D927.0B537570--