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