Re: [ask] count items in the SET(value1,value2,value3)

2012-09-25 Thread Morning Star
On Tue, Sep 25, 2012 at 12:31 AM, Rick James wrote: > SET foo (...) > Maybe: > SELECT BIT_COUNT(foo) ... > It works. Thanks! :) Greetings, Marco -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

RE: [ask] count items in the SET(value1,value2,value3)

2012-09-24 Thread Rick James
SET foo (...) Maybe: SELECT BIT_COUNT(foo) ... > -Original Message- > From: Morning Star [mailto:morning.star.c...@gmail.com] > Sent: Monday, September 24, 2012 7:02 AM > To: mysql@lists.mysql.com > Subject: [ask] count items in the SET(value1,value2,value3) > > H

[ask] count items in the SET(value1,value2,value3)

2012-09-24 Thread Morning Star
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 ='value1, value2, value3, value4, value5' ; the question is: how can i c