select
LEFT(filed,charindex(',',field,1)-1) as type,
SUBSTRING(filed,34,CHARINDEX(',',filed+',',1)-1)
from table where id = 'sdfdsfsfds'
转载于:https://www.cnblogs.com/handsome1013/p/11041586.html
select
LEFT(filed,charindex(',',field,1)-1) as type,
SUBSTRING(filed,34,CHARINDEX(',',filed+',',1)-1)
from table where id = 'sdfdsfsfds'
转载于:https://www.cnblogs.com/handsome1013/p/11041586.html