Posted by zac.carey on 02/24/06 18:03

SELECT lexicon_id, GROUP_CONCAT( keyword ORDER BY keyword SEPARATOR ',
' ) AS list FROM keywords
GROUP BY lexicon_id
ORDER BY lexicon_id

• Next in forum: Re: PHP Page and Database Not Interfacing
• Prev in forum: Re: Joining many results from one table with one result from another in one query
• Thread view: Re: Joining many results from one table with one result from another in one query

[Reply to this message]