SELECT [Keyword_Name] as 关键词
,len([SearchEngine_GPID])-len(replace([SearchEngine_GPID],',',''))+1 as 媒体个数
FROM [IWT_Keyword]
GO
SQL 算出一个字符串逗号隔开的字符串数量
最新推荐文章于 2021-05-16 14:09:43 发布
SELECT [Keyword_Name] as 关键词
,len([SearchEngine_GPID])-len(replace([SearchEngine_GPID],',',''))+1 as 媒体个数
FROM [IWT_Keyword]
GO