wyszukac '1' w catX i podac ile razy Opcje

[POLVIP]

kolejny orzech do zgryzienia
nie jestem pewny czy to można to rozwiązać tylko przy mySQL

mam tabelę z id, cat1,cat2,cat3,cat4...cat76
id to INT(4)
cat1-75 to tinyint(1)
w zależności czy jest lub nie ma jest 0 i 1 np:

id=12, cat1=0, cat2=1, cat3=1, cat4=0....
id=13, cat1=1, cat2=1, cat3=0, cat4=1....

Jak teraz uzyskać wynik na ile 1 jest w kazdym z cat np:

cat1 = 34
cat2 = 44
cat75 = 8

Czy uda sie to zrobic tylko w SELECT?
Jesli nie, jaki bybly najlatwiejszy sposob na połączenie z php?

[POLVIP]

[sql:1:8de9302965]
CREATE TABLE `categories` (
`id` int(6) NOT NULL default '0',
`reference_id` int(4) NOT NULL default '0',
`reference_type` varchar(10) NOT NULL default '',
`cat1` tinyint(1) default '0',
`cat2` tinyint(1) default '0',
`cat3` tinyint(1) default '0',
`cat4` tinyint(1) default '0',
`cat5` tinyint(1) default '0',
`cat6` tinyint(1) default '0',
`cat7` tinyint(1) default '0',
`cat8` tinyint(1) default '0',
`cat9` tinyint(1) default '0',
`cat10` tinyint(1) default '0',
`cat11` tinyint(1) default '0',
`cat12` tinyint(1) default '0',
`cat13` tinyint(1) default '0',
`cat14` tinyint(1) default '0',
`cat15` tinyint(1) default '0',
`cat16` tinyint(1) default '0',
`cat17` tinyint(1) default '0',
`cat18` tinyint(1) default '0',
`cat19` tinyint(1) default '0',
`cat20` tinyint(1) default '0',
`cat21` tinyint(1) default '0',
`cat22` tinyint(1) default '0',
`cat23` tinyint(1) default '0',
`cat24` tinyint(1) default '0',
`cat25` tinyint(1) default '0',
`cat26` tinyint(1) default '0',
`cat27` tinyint(1) default '0',
`cat28` tinyint(1) default '0',
`cat29` tinyint(1) default '0',
`cat30` tinyint(1) default '0',
`cat31` tinyint(1) default '0',
`cat32` tinyint(1) default '0',
`cat33` tinyint(1) default '0',
`cat34` tinyint(1) default '0',
`cat35` tinyint(1) default '0',
`cat36` tinyint(1) default '0',
`cat37` tinyint(1) default '0',
`cat38` tinyint(1) default '0',
`cat39` tinyint(1) default '0',
`cat40` tinyint(1) default '0',
`cat41` tinyint(1) default '0',
`cat42` tinyint(1) default '0',
`cat43` tinyint(1) default '0',
`cat44` tinyint(1) default '0',
`cat45` tinyint(1) default '0',
`cat46` tinyint(1) default '0',
`cat47` tinyint(1) default '0',
`cat48` tinyint(1) default '0',
`cat49` tinyint(1) default '0',
`cat50` tinyint(1) default '0',
`cat51` tinyint(1) default '0',
`cat52` tinyint(1) default '0',
`cat53` tinyint(1) default '0',
`cat54` tinyint(1) default '0',
`cat55` tinyint(1) default '0',
`cat56` tinyint(1) default '0',
`cat57` tinyint(1) default '0',
`cat58` tinyint(1) default '0',
`cat59` tinyint(1) default '0',
`cat60` tinyint(1) default '0',
`cat61` tinyint(1) default '0',
`cat62` tinyint(1) default '0',
`cat63` tinyint(1) default '0',
`cat64` tinyint(1) default '0',
`cat65` tinyint(1) default '0',
`cat66` tinyint(1) default '0',
`cat67` tinyint(1) default '0',
`cat68` tinyint(1) default '0',
`cat69` tinyint(1) default '0',
`cat70` tinyint(1) default '0',
`cat71` tinyint(1) default '0',
`cat72` tinyint(1) default '0',
`cat73` tinyint(1) default '0',
`cat74` tinyint(1) default '0',
`cat75` tinyint(1) default '0',
PRIMARY KEY (`reference_id`),
KEY `id` (`id`)
) TYPE=MyISAM;[/sql:1:8de9302965]

tutaj