List:General Discussion« Previous MessageNext Message »
From:Morning Star Date:September 24 2012 2:01pm
Subject:[ask] count items in the SET(value1,value2,value3)
View as plain text  
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) ?


[ask] count items in the SET(value1,value2,value3)Morning Star24 Sep
  • RE: [ask] count items in the SET(value1,value2,value3)Rick James24 Sep
    • Re: [ask] count items in the SET(value1,value2,value3)Morning Star25 Sep