摘要： 将Name字段JSON解析出来 SELECT ID,JSON_EXTRACT(`Name`,'$.Name') AS `Name`,JSON_EXTRACT(`Name`,'$.Age') AS Age,JSON_EXTRACT(`Name`,'$.Sex') AS Sex FROM test 结果 阅读全文

摘要： 将Name字段以逗号分隔展示 SELECT Id, substring_index( substring_index( a.Name, ',', b.help_topic_id + 1 ), ',',- 1 ) AS Name FROM test a JOIN mysql.help_topic b 阅读全文