Counting number of values in a SET column

[Luke Bowerman]

Okay so I'm stumped. What I want to do is run a query that can tell me 
the average number of selected values in a set column.

With the column:
mySetCol SET ('cat','dog','mouse','giraffe','lion')
A row with the value "dog,mouse,lion" would return 3
A row with the value "cat,giraffe" would return 2
I've been able to get the MySQL server to give me a binary version of 
the data...

Code:
SELECT RPAD(BIN(mySetCol+0),5,'0') AS bin from projects;
+-------+
| bin   |
+-------+
| 11111 |
| 11111 |
| 11000 |
| 10000 |
| 10110 |
+-------+
If there was some way to count the occurence of the number "1" within 
the string I'd have my number but I don't know of anyway to that within 
MySQL.

Anyone have thoughts about how I can do this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]