Re: SUM value like 10,23,15,10

[Johan De Meersman]

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.tompkins@stripped
> 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 <vegivamp@stripped>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.tompkins@stripped> wrote:
>>
>>> Yeah these values are held with a varchar field.
>>>
>>>
>>> On Tue, Aug 24, 2010 at 2:56 PM, Johan De Meersman <vegivamp@stripped
>>> >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.tompkins@stripped> 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