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