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 wrote:
> The application is still being developed, so I will probably look at
> storing it in separate tables so that it can easi
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 wrote:
> Then you're pretty much on your own, I'm afraid. Not a very good way to
> store data :-)
>
> You could
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 wrote:
> Yeah these values are held with a varchar field.
>
>
>
Yeah these values are held with a varchar field.
On Tue, Aug 24, 2010 at 2:56 PM, Johan De Meersman 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 th
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 wrote:
> Hi
>
> In MySQL is
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
