The proper way to do this would indeed be a separate table that has (itemID, property, value) or something like that.
On Tue, Aug 24, 2010 at 4:04 PM, Tompkins Neil <neil.tompk...@googlemail.com > wrote: > 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 >> > > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel