[RESOLVED] string concatenation
Is it possible to write function like SUM() but for strings?
I have a table categories with fields id, name, parent_id
and I need a query something like this:
where STR_SUM() - a function for string concatenation.
select *, STR_SUM(category.name) as cat_name from categories
group by category.parent_id
It has to return a list like this: 'cat1, cat2, cat3'
Last edited by kromol; 09-22-2011 at 09:56 AM.
Thank you very much!
It is that I need.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)