Then you're pretty much on your own, I'm afraid. Not a very good way to store data :-)
You could maybe build a stored procedure, or do it in the app; but it's gonna be code either way. On Tue, Aug 24, 2010 at 3:58 PM, Tompkins Neil <neil.tompk...@googlemail.com > wrote: > Yeah these values are held with a varchar field. > > > On Tue, Aug 24, 2010 at 2:56 PM, Johan De Meersman <vegiv...@tuxera.be > >wrote: > > > 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 < > > neil.tompk...@googlemail.com> 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 > > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
