app_recurrenceexception列已删除约会日期.
我就是这样实现的
SELECT
app_recurrenceexception,
(SELECT GROUP_CONCAT(LEFT(SUBSTRING_INDEX(SUBSTRING_INDEX(app_recurrenceexception, ',', numbers.n), ',', -1), 8) SEPARATOR ',')
FROM
(
SELECT 1 + a.N + b.N * 10 + c.N * 100 AS n
FROM
(SELECT 0 AS N UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3
UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6
UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS a
CROSS JOIN
(SELECT 0 AS N UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3
UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6
UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS b
CROSS JOIN
(SELECT 0 AS N UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3
UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6
UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS c
) AS numbers
WHERE
numbers.n <= 1 + (LENGTH(app_recurrenceexception) - LENGTH(REPLACE(app_recurrenceexception, ',', '')))
) AS modified_date
FROM
`bm_appointment`
WHERE
app_eventid = 15;
但我想要简单的输出方式
Select (20240402T073000Z,20240405T073000Z,20240408T073000Z,20240411T073000Z)从bm_appointment
如何拆分MSQL查询中每个逗号分隔值的前8个单词.如何从上面的字符串中提取日期.
的工作计划是 20240402,20240405,20240408,20240411......