From: Morning Star Date: September 24 2012 2:01pm Subject: [ask] count items in the SET(value1,value2,value3) List-Archive: http://lists.mysql.com/mysql/228243 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 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