Re: Creating a string from a resultset directly in SQL ?

2005-09-16 Thread Henri-Maxime Ducoulombier
>Take a look at the GROUP_CONCAT function, under "functions for use with >GROUP BY clauses" in the MySQL manual. You'll need MySQL 4.1+ AFAIK. Thanks a lot Jasper, that is EXACTLY what I was looking for ! Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Creating a string from a resultset directly in SQL ?

2005-09-16 Thread Henri-Maxime Ducoulombier
Hello there, I have a question regarding the possibility of creating a string from a resultset directly using an SQL command. I'm not sure if this is possible. Here is what I have: A table with links between articles and category in a catalog. For ArticleID #1, I have say 3 categories, and I woul