本文介绍了一种使用SQL进行复杂字符串操作的方法，通过多个SUBSTRING_INDEX函数组合实现特定字段的拆分和提取。具体展示了如何从一个包含分号的字符串中提取不同部分，并结合LEFT JOIN进行数据关联。
SELECT
SUBSTRING_INDEX(a.TimeString, ';', 1) AS c1,
SUBSTRING_INDEX(
SUBSTRING_INDEX(a.TimeString, ';', 2),
';' ,- 1
) AS c2,
SUBSTRING_INDEX(a.TimeString, ';', 2) AS c3
FROM
ras_attresultrecord AS a
LEFT JOIN ras_users AS u ON a.UID = u.UID
WHERE
AttDate BETWEEN "20170201"
AND "20170331"
SUBSTRING_INDEX(a.TimeString, ';', 1) AS c1,
SUBSTRING_INDEX(
SUBSTRING_INDEX(a.TimeString, ';', 2),
';' ,- 1
) AS c2,
SUBSTRING_INDEX(a.TimeString, ';', 2) AS c3
FROM
ras_attresultrecord AS a
LEFT JOIN ras_users AS u ON a.UID = u.UID
WHERE
AttDate BETWEEN "20170201"
AND "20170331"
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
