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) > > 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 count that items ( value1 till > value5) ? > > Greetings, > > Marco > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
