Re: Group by and concatenate

2006-10-11 Thread Dan Buettner
Andrew, very possible, have a look at the GROUP_CONCAT function: http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html Dan On 10/11/06, Andrew Braithwaite <[EMAIL PROTECTED]> wrote: Hi, I have the following data: mysql> select Dealername,pc from ford_gb where pc='LE4 7SL'; +---

RE: Group by and concatenate

2006-10-11 Thread Andrew Braithwaite
Never mind. mysql> select Dealername,pc,group_concat(pc) from ford_gb where pc='LE4 7SL' group by 1; ++-+--+ | Dealername | pc | group_concat(pc) | ++-+--+ | CD Bramall - Leicester | LE