mysql与groupconcat相反的_mysql GROUP_CONCAT 以及 其逆过程

新建多选选项表types 以及 选择结果表 user_MultiSelect

DROP TABLE IF EXISTS `types`;

CREATE TABLE `types` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`types` smallint(6) NOT NULL,

`comment` varchar(10) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

/*Data for the table `types` */

insert into `types`(`id`,`types`,`comment`) values

(1,1,'a'),

(2,2,'b'),

(3,3,'c'),

(4,4,'d'),

(5,5,'e'),

(6,6,'f'),

(7,7,'g'),

(8,8,'h'),

(9,9,'i'),

(10,10,'j');

/*Table structure for table `user_MultiSelect` */

DROP TABLE IF EXISTS `user_MultiSelect`;

CREATE TABLE `