create table test

( code varchar(10),

  single_No varchar(100))

 insert into  test(code,single_No)

 select '001',',201801001,201801004,201801005,201801006,'

 union 

 select '002',',201801002,201801003,201801009,201801007,201801008,'

;with temp as 

( select a.code,a.single_No, charindex(',',a.single_No) as start, charindex(',',a.single_No)-1 as lenth

  from test a

  union all

  select b.code,b.single_No,charindex(',',b.single_No,start+1), charindex(',',b.single_No,start+1)-start-1 as lenth

  from temp b 

  where start<>0

)

select  top(100) percent substring(single_No,start -lenth,lenth) as obj, code

into #te

from temp

where (start <> 0)

order by code

用截取函数呢，如果多行不确定 就要用存储过程

新建一个a表

CREATE TABLE `a` (

  `ut` varchar(255) DEFAULT NULL,

  `so` varchar(1000) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `a` VALUES ('ut1', 'so1');

INSERT INTO `a` VALUES ('ut2', 'so2;so3');

INSERT INTO `a` VALUES ('ut3', 'so4;so5;so6');

然后sql如下：

select ut ,so from (

SELECT ut,substring_index(substring_index(a.so,';',b.help_topic_id+1),';',-1) as so from  (

 select ut ,so from  a

) a

join

mysql.help_topic b

on b.help_topic_id < (length(a.so) - length(replace(a.so,';',''))+1) 

where  LENGTH(substring_index(substring_index(a.so,';',b.help_topic_id+1),';',-1))>0 ) c

其中mysql.help_topic 这个表是mysql自带的，可以直接用就行，你只需要替换我其中ut和so字段就行了