Help with mysql query
| From: | Daniel Alsén | Date: | Tue, 11 Dec 2001 23:09:03 +0000 |
| Subject: | Help with mysql query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-77375@lists.php.net to get a copy of this message | ||
Even if this isn´t a mysql forum i hope to get some help on this:
I have a table with 5 columns (named one to five) which contains numerical
values between 1 and 10.
I am trying to construct a query that gives me the count of the
representation of each numerical value (ie how many fives that are stored).
Can i do this in a smart way without having to write fifty queries and add
every fifth of them up?
Regards
# Daniel Alsén | www.mindbash.com #
# d@mindbash.com | +46 704 86 14 92 #
# ICQ: 63006462 | +46 8 694 82 22 #
# PGP: http://www.mindbash.com/pgp/ #