Substr和replace 分割

Substr(replace(replace(replace(t.contactids,'[{"id":"',''),'","name":"',','),'"}]',''),1,Instr(replace(replace(replace(t.contactids,'[{"id":"',''),'","name":"',','),'"}]',''), ',') - 1) ；