From: Johan De Meersman Date: August 24 2010 1:56pm Subject: Re: SUM value like 10,23,15,10 List-Archive: http://lists.mysql.com/mysql/222647 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cd58dc6799389048e92223b --000e0cd58dc6799389048e92223b Content-Type: text/plain; charset=ISO-8859-1 If you're looking at the string "10,23,15,10" in a single field, you'll have to do it the hard way. If you have an int field, and four rows with those values, you can do a group by that field and select the count() of it. On Tue, Aug 24, 2010 at 3:53 PM, Tompkins Neil wrote: > Hi > > In MySQL is it possible to SUM a field which contains like 10,23,15,10. > The > result I'd be looking for is > > 10 = count of 2 > 23 = count of 1 > 15 = count of 1 > > Cheers > Neil > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --000e0cd58dc6799389048e92223b--