From: Rick James
Date: September 24 2012 5:31pm
Subject: RE: [ask] count items in the SET(value1,value2,value3)
List-Archive: http://lists.mysql.com/mysql/228251
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148CF919D5@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

SET foo (...)
Maybe:
SELECT BIT_COUNT(foo) ...


> -----Original Message-----
> From: Morning Star [mailto:morning.star.crew@stripped]
> Sent: Monday, September 24, 2012 7:02 AM
> To: mysql@stripped
> Subject: [ask] count items in the SET(value1,value2,value3)
>=20
> Hi guys,
> i created a table, one of column named categories contain SET as its
> data type. let's say there are N-value in that column.
> i inserted a row to that column which contain only 5 values.
> INSERT INTO table SET categories =3D'value1, value2, value3, value4,
> value5' ; the question is: how can i count that items ( value1 till
> value5) ?
>=20
> Greetings,
>=20
> Marco
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql