Re: Counting number of values in a SET column

2005-03-30 Thread Paul DuBois
At 16:06 -0800 3/30/05, Hassan Schroeder wrote: Luke Bowerman wrote: 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

Re: Counting number of values in a SET column

2005-03-30 Thread Hassan Schroeder
Luke Bowerman wrote: 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... SELECT RPAD(BIN(mySetC