MySQL 8 用逗号分割字符串并将其转换为 JSON ARRAY [英] MySQL 8 split string by comma and convert it into JSON ARRAY

问题描述

我有以下字符串:"a,b,c,d" 我想把它转换成一个 json 数组，就像这样 ["a","b","c","d"] 有没有什么 MySQL 8 函数可以实现这个?

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?

推荐答案

尝试:

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

请参阅 dbfiddle.

这篇关于MySQL 8 用逗号分割字符串并将其转换为 JSON ARRAY的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！