Fantastic!
This is my function!!
Thanks
Jorge
> -----Original Message-----
> From: Randy Clamons [mailto:randy@stripped]
> Sent: segunda-feira, 30 de Junho de 2008 18:34
> To: Jorge Bastos
> Cc: win32@stripped
> Subject: Re: Offtopic help
>
> Use the GROUP_CONCAT() function. Quote from the manual:
>
> GROUP_CONCAT(expr)
>
> This function returns a string result with the concatenated non-NULL
> values from a group. It returns NULL if there are no non-NULL values.
> The full syntax is as follows:
>
> GROUP_CONCAT([DISTINCT] expr [,expr ...]
> [ORDER BY {unsigned_integer | col_name | expr}
> [ASC | DESC] [,col_name ...]]
> [SEPARATOR str_val])
>
> mysql> SELECT student_name,
> -> GROUP_CONCAT(test_score)
> -> FROM student
> -> GROUP BY student_name;
>
> Or:
>
> Set the separator to ";". You must be using version 5.0 or higher, but
> since you are talking functions and procedures you probably are.
>
> BTW, mySql will not concatenate strings using +. "Select 'first ' +
> 'second'" returns "0" as the result.
>
> Randy Clamons
> Systems Programming
> randy@stripped
>
>
>
> Jorge Bastos wrote:
> > 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?
> >
> >
> >
