Group by and concatenate

2006-10-11 Thread Andrew Braithwaite
Hi, I have the following data: mysql select Dealername,pc from ford_gb where pc='LE4 7SL'; +-+-+ | Dealername | pc | +-+-+ | CD Bramall Ford - Leicester | LE4 7SL | | CD Bramall Ford - Leicester | LE4

RE: Group by and concatenate

2006-10-11 Thread Andrew Braithwaite
| LE4 7SL | LE4 7SL | | CD Bramall Trucks | LE4 7SL | LE4 7SL,LE4 7SL | ++-+--+ Andrew -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wed, 11 Oct 2006 14:32 To: mysql@lists.mysql.com Subject: Group

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';