|
Posted by Piotr Chmielewski on 02/24/06 12:34
Użytkownik "laptop" <laptopaliasathotmail.com> napisał w wiadomości news:43fed070$0$29565$da0feed9@news.zen.co.uk...
> Would it?
> Have you tested it?
>
Obviously, your query would return for given earlier example
something like this:
+----+---------------------------------+------------+-----------+
| id | description | lexicon_id | keyword |
+----+---------------------------------+------------+-----------+
| 1 | Well known programming language | 1 | basic |
| 1 | Well known programming language | 1 | pascal |
+----+---------------------------------+------------+-----------+
while I need result like this:
+----+---------------------------------+------------+-----------+
| id | description | lexicon_id | keyword |
+----+---------------------------------+------------+-----------+
| 1 | Well known programming language | 1 | basic, pascal |
+----+---------------------------------+------------+-----------+
Simply I want to join ALL keywords linked to same description
and return string in ONE query. I doubt it is possible using MySQL
builtin functions but wanted to be sure before I give up...
Piotr
[Back to original message]
|