MySQL 8.0

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

CREATE TABLE response (id INT, value TEXT)
SELECT 1 id, 'honda,activa,plea"sure,car' value;

Records: 1  Duplicates: 0  Warnings: 0

SELECT response.id, jsontable.value
FROM response
CROSS JOIN JSON_TABLE(CONCAT('["', REPLACE(REPLACE(value, '"', '\\"'), ',', '","'), '"]'),
                      '$[*]' COLUMNS (value TEXT PATH '$')) jsontable;

id
value

1
honda

1
activa

1
plea"sure

1
car

SELECT CONCAT('["', REPLACE(REPLACE(value, '"', '\\"'), ',', '","'), '"]')
FROM response

CONCAT('["', REPLACE(REPLACE(value, '"', '\"'), ',', '","'), '"]')

["honda","activa","plea"sure","car"]