Posted by Piotr Chmielewski on 02/24/06 21:42

Uzytkownik <zac.carey@gmail.com> napisal w wiadomosci news:1140807180.992331.141630@u72g2000cwu.googlegroups.com...
> :-) or even...
>
> SELECT lexicon_id, description, GROUP_CONCAT( keyword
> ORDER BY keyword
> SEPARATOR ', ' ) AS list
> FROM keywords
> LEFT JOIN lexicon ON lexicon_id = id
> WHERE lexicon_id =2
> GROUP BY lexicon_id
>
> I can't think why you would need to include the id/lexicon_id twice in
> your results so I left it out.
>
Man! That's awesome, exactly what I wanted! Only problem is
that it screws polish national characters in keywords when I'm
using ISO-8859-2 encoding for tables. Hopefully somehow I'll
fix it myself. Big thanks!!

Piotr

• Next in forum: Re: Joining many results from one table with one result from another in one query
• Prev in forum: Re: help - isolate specific xml from mySQL entry?
• Thread view: Re: Joining many results from one table with one result from another in one query

[Reply to this message]