We were unable to load Disqus. If you are a moderator please see our troubleshooting guide.

Jeff • 4 years ago

hi Taryn;
thanks for all your comments they help . I have a string "FABRIC > CHELSEA, FABRIC, FLORAL, FLORAL > MEDIUM FLOWERS" and would like to use mysql split into columns by delimiter "," . can you help. thanks .jeff

Malcolm • 1 year ago

SET @a = 'FABRIC > CHELSEA, FABRIC, FLORAL, FLORAL > MEDIUM FLOWERS';

SELECT t.value
FROM JSON_TABLE
(
CONCAT('[{"value":"', REPLACE(@a, ',', '"},{"value":"'), '"}]'),
'$[*]' COLUMNS (value VARCHAR(100) PATH '$.value')
) AS t;

you can do this in mysql Jeff