MySQL 8 split string by comma and convert it into JSON ARRAY

Question

I have the following string: "a,b,c,d" and I want to convert it into a json array, something like this ["a","b","c","d"] is there any MySQL 8 function that can achieve this?

wchiquito · Accepted Answer · 2019-07-12 17:09:48Z

6

Try:

SELECT
  CAST( 
    CONCAT('["', REPLACE('a,b,c,d', ',', '","'), '"]')
    AS JSON
  );

See dbfiddle.

answered Jul 12, 2019 at 17:09

wchiquito

16.6k2 gold badges37 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dave Stokes · Accepted Answer · 2019-07-09 21:03:36Z

-4

select json_array("a,b,c,d");
+-----------------------+
| json_array("a,b,c,d") |
+-----------------------+
| ["a,b,c,d"]           |
+-----------------------+

answered Jul 9, 2019 at 21:03

Dave Stokes

8235 silver badges11 bronze badges

1 Comment

John Over a year ago

you've create an array with one entry

Collectives™ on Stack Overflow

MySQL 8 split string by comma and convert it into JSON ARRAY

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related