1,如图
代码如下
substring_index(str,delim,count)
str:要处理的字符串
delim:分隔符
count:计数
SELECT
a.Id,
substring_index(
substring_index(
a.site_raw_evidence_urls,
',',
b.help_topic_id + 1
),
',' ,- 1
) AS raw_evidence_url
FROM
ftz_attestation_supervision_site a
JOIN mysql.help_topic b ON b.help_topic_id < (
length(a.site_raw_evidence_urls) - length(
REPLACE (a.site_raw_evidence_urls, ',', '')
) + 1
)
2,
筛选某个字符串并用逗号分隔,并显示最后一条
如图
代码如下
substring_index(str,delim,count)
str:要处理的字符串
delim:分隔符
count:计数
SELECT
Id,
substring_index(site_raw_evidence_urls,',' ,- 1
)
FROM
ftz_attestation_supervision_site