MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable (csv TEXT)
SELECT 'john;doe;12;john@example.com' AS csv;
CREATE VIEW my_view AS
SELECT CONVERT(SUBSTRING_INDEX(SUBSTRING_INDEX(csv, ';', 2), ';', -1), CHAR(255)) AS test
FROM mytable;
CREATE TABLE test
SELECT * FROM my_view;
SHOW CREATE TABLE test;


Table
Create Table


test
CREATE TABLE `test` (
  `test` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci