List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:August 24 2010 1:58pm
Subject:Re: SUM value like 10,23,15,10
View as plain text  
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
>

Thread
SUM value like 10,23,15,10Tompkins Neil24 Aug
  • Re: SUM value like 10,23,15,10Johan De Meersman24 Aug
    • Re: SUM value like 10,23,15,10Tompkins Neil24 Aug
      • Re: SUM value like 10,23,15,10Johan De Meersman24 Aug
        • Re: SUM value like 10,23,15,10Tompkins Neil24 Aug
          • Re: SUM value like 10,23,15,10Johan De Meersman24 Aug