使用MySQL从包含列值的所有单个单词的表colum创建视图？

CREATE VIEW view_name AS
SELECT DISTINCT word
FROM (
  SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(colum, ' ', n), ' ', -1) AS word
  FROM table_name
  CROSS JOIN (
    SELECT 1 + units.i + tens.i * 10 AS n
    FROM (
      SELECT 0 AS i 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
    ) units
    JOIN (
      SELECT 0 AS i 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
    ) tens
    ORDER BY n
  ) numbers
  WHERE word != ''
) words;