Solved
MYSQL Function help needed to return a string comma separated
Posted on 2014-01-06
Hi Experts.
I trying to create a function that must return a string of keywords, comma separated. The last comma must be dropped.
example: (professional makeup artist, professional makeup brands, professional makeup courses, professional makeup kits)
I am getting the following error:
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RETURN SKW' at line 68
The query returns the results when not put inside the function but I think I have an issue with syntax or something for the function.
Could someone have a look at this function and let me know what the problem is.
The the second part once error identified is how do I get the result to be RETURNED as a string comma separated?
Any help will be appreciated.
Regards
Matt