如何在SQL中选择两个相同字符之间的字符串

SELECT SUBSTRING(column_name, CHARINDEX('相同字符', column_name) + 1, CHARINDEX('相同字符', column_name, CHARINDEX('相同字符', column_name) + 1) - CHARINDEX('相同字符', column_name) - 1) AS result
FROM table_name
WHERE column_name LIKE '%相同字符%相同字符%';

WITH recursive cte AS (
  SELECT 1 AS start_pos, CHARINDEX('相同字符', column_name) AS end_pos
  FROM table_name
  WHERE column_name LIKE '%相同字符%'
  UNION ALL
  SELECT end_pos + 1, CHARINDEX('相同字符', column_name, end_pos + 1)
  FROM cte
  WHERE CHARINDEX('相同字符', column_name, end_pos + 1) > 0
)
SELECT SUBSTRING(column_name, start_pos + 1, end_pos - start_pos - 1) AS result
FROM cte;