The application is still being developed, so I will probably look at storing it in separate tables so that it can easily be computed.
On Tue, Aug 24, 2010 at 3:01 PM, Johan De Meersman <vegiv...@tuxera.be>wrote: > 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 >
