MySQL Forums
Forum List  »  Newbie

Having a query return a comma-delimited list
Posted by: Kai Jaeger
Date: July 10, 2005 03:08AM

Hi there!

I have the following query

SELECT category_name FROM item_categories, categories
WHERE item_categories.item_id = 10001 AND categories.language_id = 1 AND
item_categories.category_id = categories.category_id

which works as expected and returns a list of category names.
Now I was wondering if it's possible to instead have it return a single row with one column containing all category names as a comma-delimited list.
I have experimented with this for a while and I'm getting the impression that this is in fact not possible, but I'd like to make sure it actually can't be done (easily and effectively) before I give up on it.

Thanks in advance!

Options: ReplyQuote


Subject
Written By
Posted
Having a query return a comma-delimited list
July 10, 2005 03:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.