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?
>
>
>
